slifer666
Master Duelist
- Local time
- Today, 19:50
- 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?
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?