-
Search part of name field
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.
-
Try: Like '*' + [Forms]![Search]![SearchField] + '*'
I assume that you're using Access, right?
-
It worked!
Thanks alot Rawhide!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|