FILTERING RECORDS IN SUBFORM BASED CBOX VALUE

  • Thread starter Thread starter BRC
  • Start date Start date
B

BRC

Can anyone direct me to a simple explanation of how this works. I am trying
to find records in a subform (datasheet view)based on a value selected (or
typed) in a combo box on the main form. I know it has to do with linking
child/master fields etc but I need kind of a step by step explanation.
Thanks for any help or direction.
 
1. Open the form in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. On the Data tab of the Properties box, enter the name of the combo beside
Link Master Fields.

4. Enter the name of the matching field in the subform beside the Link Child
Fields property.

The subform will now show no records until you choose something in the
combo. It will then contain all records that match the value in the combo.
 
Thank you Allen. Thats what i needed. using access 2000 the combo box is not
an option in the drop down. Just one of those things you have to "know".
thanks againd
BRC
 
Back
Top