Microsoft Access Search button (vba combo box) issue

[toolongdidntread]

So my co-worker created a form using VBA to search room details of the terminal, I find that the same result will pop up after I make another search even I am searching for another room. Below is the vba she wrote. Please help if she miss anything or should I do some settings on the database.


Option Compare Database
Private Sub ComboAccommodationType_AfterUpdate()
Me.ComboArea.Requery
End Sub


Private Sub ComboTenantSubtype_Click()
End Sub


Private Sub ComboUnitNo_AfterUpdate()
Me.ComboAccommodationType.Requery
Me.ComboArea.Requery
End Sub


​Many thanks!

[June7]

All that code does is requery comboboxes. There is no search code. We need to see properties of comboboxes and forms. If you want to provide db for analysis, follow instructions at bottom of my post.