Hello everyone. I am currently creating an Access 2007 database to keep track of technology assets for warranty, tagID#, and what location it is at.
Currently, I have just a single table called "Assets" with all the information. I created a form using just that table and put an unbound combobox in the header with a search button. This is to just search through the location of the fields currently in the table.
My code for the search button is:
Private Sub Command32_Click()
Me.Filter = "Location= " & Chr(34) & coboLocation.Column(1) & Chr(34)
Me.FilterOn = True
I click the button and absolutely nothing happens at all. All three test records are still present, nothing changes. I am completely unsure what is going on here.
Last edited by seuta; 01-04-12 at 18:23.
Reason: Clarification and ytops.