Search part of name field

C

CSCS

Joined
Jul 23, 2005
Messages
2
Reaction score
0
Hi Guys!

I'm working on this database in which I have 2 forms:

one form has personal information (PersonalInfo)
and the other one is a search form (Search)

In the search form I have a field in which I want to type any part of the Name field in PersonalInfo form and I want to retrieve all the records that have this part of the name.

Here is what I tried:

In the PersonalInfo form, I want to the criteria of the NameField and typed the following:

Like %[Forms]![Search]![SearchField]%

but it didn't work.

Any help will be very much appreciated.

Regards,
CS.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the calling form. 4
filtering with data relations 3
part of multi search query non-functional 4
Access Need help in making asset history in my current database. 1
use field list from form to specify query fields 2
Using 2 form fields as one criterium 8
search facility 8
Applying Wildcard for search 1

Back
Top