A Query on Queries

slifer666

Master Duelist
Local time
Today, 07:55
Joined
Oct 20, 2005
Messages
25
Hi, i am using queries to run searches on a table

I am using this code: [Forms]![frmDescr]![txtDescr]

I want to be able to enter part of what i am searching for (eg Generic) and it bring up everything with "Generic" in it, instead it will only find things if the complete contents of the cell are entered (eg Generic Room Data / Generic Drawings)

How can i get it to search in the way i have stated?
 
Make your criteria:

Like [Forms]![frmDescr]![txtDescr] & "*"

Should do the trick
 
Boss!! That did the trick perfectly

Thank You Mate!!
 
Or if you want to match on the word anywhere in the field:
Like "*" & [Forms]![frmDescr]![txtDescr] & "*"
 

Users who are viewing this thread

Back
Top Bottom