Unanswered: Combo box that limits criteria based on previous criteria in a sub form
I was wondering if any of you fine folks could explain this problem to me. I have a form with 2 combo boxes. The first contains Events and is loaded from a table. The second is loaded from a query and is loaded with just the Happenings that meet that Event. The query contains 2 tables-Events and Happenings. The query criteria for the Event is [Forms]![frmsbEventLog]![Event] and it just shows the Happenings that meet that Event.
It works great when the form is opened by itself. When I make that a subform in a larger form though, I can choose the Event. However, when I get to the Happening, I get a dialog box that pops up asking for the Event value in the subform that I just picked, or [Forms]![frmsbEventLog]![Event]. It won't load it like it would when it was a straight form.
Anybody know what I am doing wrong? Any help on this matter would be greatly appreciated.