By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Searching on a text field

P: n/a
Hi all,

I currently have a form with 3 text fields that I wish to use as my
search criteria. I am having trouble constructing this. So, basically
how can I use the text in these fields to serach for the required
records in a table.

Thanks in advance
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 13 Aug 2004 01:55:51 -0700, Luke Jones wrote:
Hi all,

I currently have a form with 3 text fields that I wish to use as my
search criteria. I am having trouble constructing this. So, basically
how can I use the text in these fields to serach for the required
records in a table.

Thanks in advance


In the query, using the appropriate form name and control name in each
field to be searched, use something like:
Like "*" & forms!FormName!ControlName & "*"

The above will return records if the text in ControlName is found
anywhere in that field.

Like forms!FormName!ControlName & "*"
will return records where the entered text is only at the beginning of
the field.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.