Sub form does not display records matching to the main form

[jeep2001]

I am having some trouble with a sub form behavior.
I have a key field that the user selects from a combo box.
Since there are going to be many records based on that key field, I thought a sub form would work well. The sub form would display the matching values based on that key field.

When I open the form, the sub form is displaying records that match to the first record in the form recordsource.
When i change the value in the combo box, the subform does not display the records that match on that key field.
However, if I spin the mouse wheel, then the subform acts somewhat normally.
What am i doing wrong.

 

[lars7]

You could check that the key field that you mention is indeed the link between the form and subform "Link child fields" and "link master fields" on the property sheet of the subform.

 

[jeep2001]

I am using 2003, and I don't see the link child and master fields in the property sheet.

 

[FastLearnerIThink]

Open Main Form in Design View. Select Subform, right click and select properties. You will see the Link Child and Link Master field properties on the DATA tab.


-- Fast Learner, I Think

Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

 

[jeep2001]

OK thanks...I finally got it working,.
Thanks for your help.