I have a Microsoft Access 2007 database I am working on. I have two tables (ActivityTermsT and ActivityDetailsT). I would like to set up 2 combo boxes, one with all the terms, and then the second combo box dropdown list of details will be dependent on what activity is chosen. I have created a form titled ActivityF. All information for the form is pulled from ActivityDetailsT (because I have the terms and termID's which form relationships with the details). I then create two combo boxes. The names of the first one is cboActivityTermsText and the second one is cboActivityDetailsText. I then have an ActivityF: Query Builder to populate the combo boxes. I am using the ActivityDetailsT to pull the fields for the query.

The first field in the query is ActivityTermsText, with the criteria of [Forms]![ActivityF]![cboActivityTermsText]. The second field is ActivityDetailsText with no criteria. Then I go back to the ActivityF, and for After Update", I type in the code:

Private Sub cboActivityTermsText_AfterUpdate()
cboActivityDetailsText.Requery

So the problem arises when I go back to my form. I can select the ActivityTermsText from the dropdown list in my combo box, but then when I try to select anything from the ActivityDetailsText, the dropdown list is empty.

What could I be doing wrong?

Thanks for your help, in advance.

Tom