Linking SubForm to Form (1 Viewer)

[ozsupra]

I have been unable to work this one out and I'm sure the answer is fairly simple.
I have a subform (A) that shows all records in a table in a list format. The form (B) shows only the current record.
I am attempting to click on a record on the subform list (A) and for that record to display on the form (B). Both forms (A) and (B)are using the same table.
Any assistance would be grateful.
Many Thanks.

 

[MarkK]

For record navigation, use a listbox instead of a subform. A subform is way harder to use for that purpose.

 

[ozsupra]

Thanks Mark.
Whilst a listbox may be an easier option (and it is) sometimes it just isn't the solution that works best for the end user.
I really need some guidance on refreshing the main form after clicking on a particular subform record.
Surely this can't be that difficult? ?

 

[JHB]

Have a look here, it is more or less what you want, (there are sample database in the thread also).
http://www.access-programmers.co.uk/forums/showthread.php?t=263879&page=2

 

[ozsupra]

JHB - Excellent, that's just the ticket. Thanks so much!!!

 

[JHB]

You're welcome.