subform results issue

kato68

Registered User.
Local time
Today, 07:56
Joined
May 12, 2003
Messages
45
I have a main form with a combo box on it that has ID numbers in it. On a subform I have a results datasheet. When a person chooses a new option in the combo box, the results change using me.requery. My only problem is that the first record in the query is always displayed no matter what the ID selected in the combo box is. Any ideas why this is happening?
 
You don't have your subform properly linked to the main form. Check the subform Master/Child link properties. I'll bet they they are blank and should be the combo box ID (master) and the corresponding field in the subform recordsource (child).
 

Users who are viewing this thread

Back
Top Bottom