Search part of name field

[CSCS]

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.

 

[RV]

CS,

the wild card in MS Access is *
Look up the LIKE operator in Access Help.

RV

 

[CSCS]

Dear RV,
Thanks for the hint. I found the solution!

 

[galia lonero]

Hi,
Could you send me please code for Search function.
I am trying to do same thing.

Thanks

 

[caberner]

Solution

The query expression should read as follows:

Like '*' & [Forms]![Search]![SearchField] & '*'

~Lisa