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.
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.