Creating a form with a combo box that changes subforms

[Dugantrain]

Is there a way to create a main form with a combo box that holds the primary key entries for every record and then changes the subform based on which record was selected without using VBA? I don't know much about coding and thus would like to use a form wizard or use the properties box to perform this task (essentially, what I'm looking to do is to make it so that the user can choose his record in a combo box rather than have to scroll through every record to find what he's looking for).

 

[Rich]

The Wizard will do the work for you, select find record on my form