combo boxes and sub forms

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?

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,


--
Eric Cárdenas
Senior support professional

This posting is provided "AS IS" with no warranties, and confers no rights.