combo boxes and sub forms

[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?

 

[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?

--------------------
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,