T
Timothy
After much work and help from people like John Spencer and
John Viescas, I have found a working answer for a qbf that
uses a linked query to a text box, and the criteria is: Is
not null and like "*" & [forms]![searchbox]![entry] & "*".
The short answer is creating a query from the table being
searched and place the like statement in the critera for
every field being searched from [entry]. Then create
another query from the same table, but this time use
[entry1] to search the other box. Now create a 3rd query
that uses the first two queries. Link the two queries by
thier primary keys, and place only one of the quiery
fields in the qbe (only to create a report based on this
query)
In the Form, on entry1, set the property of default vaule
to "*".
Now you can enter info into the first box and search,
which returns a broad search, or in to both boxes to
narrow the search.
If anyone has an easier, or faster way of doing this I
would love to hear it.
Thank you once again for your help, and thank you for your
patience dealing with a newbie. I really appreciate that
you were not snobbish or arrogant like some of the others.
If anyone would like help with this type of search feel
free to email me and I would be happy to fully explain it.
Timothy
John Viescas, I have found a working answer for a qbf that
uses a linked query to a text box, and the criteria is: Is
not null and like "*" & [forms]![searchbox]![entry] & "*".
The short answer is creating a query from the table being
searched and place the like statement in the critera for
every field being searched from [entry]. Then create
another query from the same table, but this time use
[entry1] to search the other box. Now create a 3rd query
that uses the first two queries. Link the two queries by
thier primary keys, and place only one of the quiery
fields in the qbe (only to create a report based on this
query)
In the Form, on entry1, set the property of default vaule
to "*".
Now you can enter info into the first box and search,
which returns a broad search, or in to both boxes to
narrow the search.
If anyone has an easier, or faster way of doing this I
would love to hear it.
Thank you once again for your help, and thank you for your
patience dealing with a newbie. I really appreciate that
you were not snobbish or arrogant like some of the others.
If anyone would like help with this type of search feel
free to email me and I would be happy to fully explain it.
Timothy