I have a basic form called WebAppExport that is showing results from a query called WebAppExportQry. The data are products in a chain of retail stores. (fields such as store number, item number, price, etc.) I currently have a search box that limits the results, based on searching the description, item number, or UPC code.
I added a combobox called StoreCombo that lists all of the store numbers. I want to be able to choose a store number and then search only the records where StoreNum = the value in StoreCombo.
Here is my search box info:
There's a text box called txtSearch
and a button called SearchBtn that has an onClick Macro with an ApplyFilter who's Where Condition =
[ItemNameWeight] Like "*" & [Forms]![WebAppExport]![txtSearch] & "*" Or [ItemNum] Like "*" & [Forms]![WebAppExport]![txtSearch] & "*" Or [ItemUPCCode] Like "*" & [Forms]![WebAppExport]![txtSearch] & "*"
I assume I need to add some code to the button onClick event that says to pull the StoreNum from the combobox and filter the form accordingly. Any suggestions how to do that properly would be appreciated.