Subform / Main Form problems...

[aceoftrades]

Hi,
I have a Main Form and a Sub Form. The Sub Form is used to search through records and display those records in a datasheet based on the search criteria (Manufacturer, Model, Color, etc). There can be many results based on the search. I need to be able to click on each record in the search results on the SubForm which will then display the rest of the fields of that record on the Main Form (Description, Image, Etc). I currently have the Sub Form working and able to filter the records. The Main Form curently displays the first record in the table. I need to figure out a way to have the record in the Main Form change based on which record I click on the Sub Form. Thank you for any help.
Joe

[June7]

Have you considered the Split form?

[aceoftrades]

I'm new to access and everything is pretty much trial and error...can you be more specific?

[June7]

Search Access Help or Google on the topic of Split form. There are lots of tutorials. On the ribbon Create tab, look at the choices for creating forms, one is the Split form.

[AcsDb]

--------------