dynamic search

[sammers101]

I attempted to follow john big booty's dynamic multi search

No errors, I followed the directions exactly..(or so I thought, several times) and nothing happens when I enter search data.

Thanks for any help

 

[John Big Booty]

Welcome to the forum.

The problem was that you hadn't set the query QRY_SearchAll as the Row Source for your List Box.

I've fixed that for you and it now works

 

[sammers101]

Thank you very much

 

[sammers101]

Wonderful script

Is there a way to search multiple fields at the same time?
for instance:
name location
john localA


and I could search john (space?) localA?
I tried the updated code and that did not show up
With the data I uploaded, you can try entering in Ball Bearing then space, many entries dissapear

Alternatively, I think it might even be better if I make a drop down box where I can select, say the location, and then search for the name but that has been giving me problems as well see post:
access-programmers.co.uk/forums/showthread.php?t=226426

If I am able to get the drop down box to work (shouldnt be hard, just doing something silly wrong), would it work well with the search script?

I think either way would work, drop down box or being able to use a space or another text box to search the multiple fields

Thanks again