Search for Records Containing Word(s) in Textbox
How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.
Software/Hardware used:
Microsoft Access 2007
Software/Hardware used:
Microsoft Access 2007
ASKED:
June 9, 2010 2:50 PM
UPDATED:
June 9, 2010 6:40 PM
RELATED QUESTIONS
- Access Listbox Without Focusing in WinForms
- Select box and enter number into hidden field
- Using combo box to populate a sub form which is used to create a new record
- Access 2007: Create a form for both display and data entry purposes
- barcode entered, still dlookup not populating "item" and "price" in the form
Answer Wiki:
Instead of the specific words, use this notation in the field criteria:
<pre>[Forms]![YourFormName]![YourTextboxName]</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
