Subform Combobox based on Main form combo box

[accessmom]

I am working on a database for milk sales to students. I am not getting any values for my subform combobox. I do not see any typos. The main form is called Sales and its combo box is FamID. The subform is called "Sales Details" and it's combobox is ChildID. When entering new data in the sales details subform I wanted to provide a dropdown box that only allows choices of children who belong to the family FamID that is selected via the combobox in the main form. The main form's control source is a Families table containing family info and the subform's control source is the "Sales Details Extended" query. The combobox ChildID's control source is ChildID but its rowsource is a query executed on a childrens table that contains children's names and childID were FamID=the FamID value of the main form combobox. If I open that query directly when the main form is open, it executes fine. When I open the main form with the subform I get no values either for the field nor for the drop down values. I am not terribly experienced programming in access so I assume I am missing something really obvious.

[RuralGuy]

In the OnEnter event of the ChildID ComboBox put:
Me.ChildID.Requery
...and see what happens.

[accessmom]

Tried this and got the following error: The expression On Enter you entered as the event property setting produced the following error: A problem occurred while MILK DATABASE was communicating with the OLE server or ActiveX Control. The code entered is:

Private Sub ChildID_Enter ()
Me.ChildID.Requery
End Sub

[RuralGuy]

Hmmm...I would start by *importing* your db into a fresh, new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

[accessmom]

Thank you so much!! I am back in business.

[RuralGuy]

That's great! Are you ready to use the Thread Tools and mark this thread as Solved?