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.

[Rawhide]

Try: Like '*' + [Forms]![Search]![SearchField] + '*'

I assume that you're using Access, right?

[cscs]

It worked!

Thanks alot Rawhide!