Yes, you could do that, but Subforms are usually used to show data that is
related to, and subsidiary to, the data on the main form. Perhaps a more
common way to do what you want is to use a ComboBox ... the ComboBox Wizard
has an option that will provide the code that uses the selection in the
Combo to locate a record for the Form -- it's just about all done for you,
already.
Larry Linson
Microsoft Access MVP
"Argus Rogue" <mr*****@yahoo.com> wrote in message
news:vH******************@fe2.texas.rr.com...
Hello All Access Guru's:
I was wondering if you could assist me with a little problem that I am
having using subform.
Is it possible to scroll down a subform to a particular record, click on
that record and have it populate the main form?