A Query on Queries

[slifer666]

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?

 

[Michael J Ross]

Make your criteria:

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

Should do the trick

 

[slifer666]

Boss!! That did the trick perfectly

Thank You Mate!!

 

[neileg]

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

 

[slifer666]

Sweet, that was awesome

Cheers Guys