Unanswered: Subform With Multiple Combo Boxes Not Querying
I have a form with a subform. On the Form are three comboboxes for different types of data, Number, Floor, and RI Name. When I have the Number set to the first Number and the Floor to the first floor, the filter updates the subform data fine on each change. However if I change either Number or Floor it does the requery but it does not show a record in the subform. Here is my code. Please help.
Private Sub cmbFloor_AfterUpdate()
Me.cmbRI_Name = Null
Me.cmbRI_Name = Me.cmbRI_Name.ItemData(0)