Wildcard queries

[FireViking]

Hi all,
The keyword search is down for maintenance so here goes.

I have created a query with multiple feilds and assigned wildcard criteria to each feild. The following is an eg.
LIKE "*" & [forms]![formname]![formfeild] & "*"
this works fine when the query is run.
I have created a form with the intention of the user entering data into any 1 or more of the feilds to perform a search using the query. I added a button to run the query using the docmd.openquery and the query works but opens the normal view spreadsheet view. I want it to populate a listbox instead where the user can view and select the relevant file as required. Is there away of stopping the normal view spreadsheet from opening? Am i using the correct od for wildcard queries?

 

[JoanneM]

Morning

Is the lisbox sourced from this query if so you could add the line

me!listboxname.requery

to check this out
enter your data selections and press F9 this will refresh the form and requery the listbox
if that works the above should too


hope this helps

regards

Jo