One Parameter, Entire Family, One Form

[Whispersplus1]

I need alittle assistance here. The database a created has a query that uses a parameter to locate specific information. The result of the parameter is a form with a sub-form (this is a good thing) The problem is that I have to scroll through (example 1 of 4 records) to detemine the correct person I'm looking for. What I would like to be able to do is utilize the parameter to call up the results and have a combo box to select which record I need.

I have attached a copy of my attempt to make this work, now I need alittle help getting it to work smoothly.

Basically when I hit next piece I don't want to have to hit the combo box as well to get the result I'm getting.

ANY HELP WOULD BE GREATLY APPRECIATED

 

[John Big Booty]

First up you will need to Normalise your DB.