Query Help!!!!

[sysop470]

hi, is it possible to have a form where you enter a word in a text box and it searchs a table and brings up all records which match it,and if it is null, it will show me all records.
e.g.
if i enter: PENCIL
it will show exact match

example
1)PENCIL
----------------------------------------------------------------
if i leave it blank
it will show me like the example, even if there is an empty record

example
1) PENCIL
2) RUBBER
3) EMPTY RECORD
4) BIRO
--------------------------------------------------------------
etc etc

Any help please..
thanks

 

[pbaldy]

http://www.mvps.org/access/queries/qry0001.htm

 

[sysop470]

http://www.mvps.org/access/queries/qry0001.htm

Thanks for your reply, but its now working

When i leave it blank, no records is displaying, as i mentioned before,

if i leave it blank
it will show me like the example, even if there is an empty record

example
1) PENCIL
2) RUBBER
3) EMPTY RECORD
4) BIRO

This is a combo box. Should i have to insert a requery command int the form??

Andy help pls
Thanks

 

[JoeyY]

What about using If/Then? If null, select all, else select based on criteria.