Hi All,
Still fairly new to Access but slowly learning.
I have a form with a built in search function and would like to place this in a navigation form. The search works ok on the form, but when I add it to the navigation form it doesn't.
The search is done by a macro on a command button:
[FirstName] Like "*" & [Forms]![SearchForm]![Text17] & "*" Or [SurName] Like "*" & [Forms]![SearchForm]![Text17] & "*" Or [Address] Like "*" & [Forms]![SearchForm]![Text17] & "*"
When I move it to the navigation form, I believe I have to change the references for the search but now matter how I try I can not get this to work.
Could someone please point me in the correct direction, been trying to solve this (probably simple) problems most of the day
Still fairly new to Access but slowly learning.
I have a form with a built in search function and would like to place this in a navigation form. The search works ok on the form, but when I add it to the navigation form it doesn't.
The search is done by a macro on a command button:
[FirstName] Like "*" & [Forms]![SearchForm]![Text17] & "*" Or [SurName] Like "*" & [Forms]![SearchForm]![Text17] & "*" Or [Address] Like "*" & [Forms]![SearchForm]![Text17] & "*"
When I move it to the navigation form, I believe I have to change the references for the search but now matter how I try I can not get this to work.
Could someone please point me in the correct direction, been trying to solve this (probably simple) problems most of the day