This is what I'm trying to do:
In a form, a user enters a value (e.g. John) and clicks on submit.
Submit opens up a query with one of its values (e.g. Name) set to the value
of the control that the user just typed "John" into.
Thus far, this works fine, and it pulls up all the records where Name =
John.
But I want it to pull up all records where Name = John, John Smith, John
Jones, John Jacobs, Father John, etc. -- in other words, if John is in any
part of the control, I want it to come back.
If I put Like "*John*" in the criteria, it works fine.
But if I put Like "[Forms]![Submit Form]![Name]*" it returns no records
(because it looks for names with the value "[Forms]!...")
If I put Like [Forms]![Submit Form]![Name]* or Like [Forms]![Submit
Form]![Name]"*" it returns with a syntax error.
Obviously I won't always be looking for John, so I would like to do this
with a variable.
Any idea how to do what I want to do? Thanks!
ph******@removethispart.hotmail.com