wild search

[jervin via AccessMonster.com]

Hi,
i had a wild query to search:

i put in the criteria:
like "*" &[Enter xxx to search]&"*"

i want to use this parameters, but my question is if i hit Enter and without
entering a word to search it shows all the data from the table. can anybody
help me..thanks again

 

[Douglas J. Steele]

What do you want it to do: return nothing?

Use

like "*" &[Enter xxx to search]&"*" And [Enter xxx to search] IS NOT NULL

Make sure you type the two [Enter xxx to search] exactly the same!

 

[jervin via AccessMonster.com]

thank you very much sir, it works....

What do you want it to do: return nothing?

Use

like "*" &[Enter xxx to search]&"*" And [Enter xxx to search] IS NOT NULL

Make sure you type the two [Enter xxx to search] exactly the same!

Hi,
i had a wild query to search:

[quoted text clipped - 7 lines]

anybody
help me..thanks again