Simple Search Form Not So Simple

seuta · #1 (**permalink**) 01-04-12, 13:11

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:

Code:

Private Sub Command32_Click()
Me.Filter = "Location= " & Chr(34) & coboLocation.Column(1) & Chr(34) 
Me.FilterOn = True
End Sub

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.

Sinndho · #2 (**permalink**) 01-05-12, 05:25

Change your code to:

Code:

Private Sub Command32_Click()

    Debug.Print "Location= " & Chr(34) & coboLocation.Column(1) & Chr(34) 
    Stop
    Me.Filter = "Location= " & Chr(34) & coboLocation.Column(1) & Chr(34) 
    Me.FilterOn = True

End Sub

Then open the Debug window (Ctrl+G), re-open the form, perform a search and see what you get for a filter: it will be displayed in the Debug (immediate) window when the code stops.

The explanation could be that the first (leftmost) column of a combobox is Column(0).

Note: With this technique, you do not perform a search on the row set, you actually filter it (i.e. the rows that do not match the criteria are excluded from the form records).

seuta · #3 (**permalink**) 01-05-12, 08:00

Quote:

Originally Posted by Sinndho

Change your code to:

Code:

Private Sub Command32_Click()

    Debug.Print "Location= " & Chr(34) & coboLocation.Column(1) & Chr(34) 
    Stop
    Me.Filter = "Location= " & Chr(34) & coboLocation.Column(1) & Chr(34) 
    Me.FilterOn = True

End Sub

Then open the Debug window (Ctrl+G), re-open the form, perform a search and see what you get for a filter: it will be displayed in the Debug (immediate) window when the code stops.

The explanation could be that the first (leftmost) column of a combobox is Column(0).

Note: With this technique, you do not perform a search on the row set, you actually filter it (i.e. the rows that do not match the criteria are excluded from the form records).

Thank you very much, Sinndho. The values being in a different column was part of the problem. Your help was very useful and greatly appreciated, thank you!

Sinndho · #4 (**permalink**) 01-05-12, 08:05

You're welcome!

Internet Services

Web Development

Digital Marketing

Consumer Tech