combo boxes and sub forms

S

steve

i have a s simple form and sub form in acess 97

i would like to place a combo box on the main form that
will select the key field of the table
on the sub form i would like have the related recoreds
displayed based on the the combo box value

how do i do this?
 
E

Eric Cárdenas [MSFT]

i have a s simple form and sub form in access 97
i would like to place a combo box on the main form that
will select the key field of the table
on the sub form i would like have the related recoreds
displayed based on the the combo box value

how do i do this?
Click to expand...
--------------------
There is a sample form which has a similar example in the Solutions
database that comes with Access 97. It uses the GoToRecord action in a
macro to find the record matching the selection in the drop down combo box.

Hope this helps,
 
Top