There is a NEWER version of this video available here: Open Form to Specific Record

In this Microsoft Access Tip, I'll show you how to create a customer list form where you can click on one customer and then click a command button to open up that customer's full record in a different form. I cover this technique (and lots more like it) in my full Access Level 7 class.