How to Retrieve data from Main form & subform based on ID field?

[BP]

I have 2 tables(A & B) linked by a common field(ID) with referential
integrity set at A(One), B(Many).
Using the wizard, I made a form & subform with their underlying record
sources from the tables A & B respectively.

I can switch records by the record navigator arrows at the bottom left of
the window. But as there are could be hundreds of records, using the arrow
button is not efficient. How do I retrieve records for both main & sub form
based on the common ID field? For eg, Maybe somewhere whereby I can key in
the ID number and both form & subform goes to the correct record/s?

Can someone Pls point me in the right direction. thanks.

BP

 

[John W. Vinson]

I can switch records by the record navigator arrows at the bottom left of
the window. But as there are could be hundreds of records, using the arrow
button is not efficient. How do I retrieve records for both main & sub form
based on the common ID field? For eg, Maybe somewhere whereby I can key in
the ID number and both form & subform goes to the correct record/s?

Use the Combo Box Wizard to put a combo box on the form, using the option "Use
this combo to find a record". Set up the combo to display some field which
will be meaningful to the user - might be an ID number, or a name.

 

[BP]

ThankS!

Use the Combo Box Wizard to put a combo box on the form, using the option "Use
this combo to find a record". Set up the combo to display some field which
will be meaningful to the user - might be an ID number, or a name.