Hello
I have several search functions in my db but I fear this one has beaten me.
I have a form, which contains a subform, which contains a subform, which contains the form 'Search Call-backs'. Within this form are several fields that the user can enter data into to conduct a search of the db to retrieve relevant records.
The criteria I need to use should be something like..
.. however this returns ALL results, despite data being in the Surname field, which is obviously incorrect.
I have tried opening the form directly rather than via the subform and using
and this works fine. As does just putting the name in asterisks..
If I try amending the path (incase I got it wrong!) by removing one of the NavigationSubforms, or adding another one, it acts as a parameter asking me for that field...
Any help would be appreciated!
I have several search functions in my db but I fear this one has beaten me.
I have a form, which contains a subform, which contains a subform, which contains the form 'Search Call-backs'. Within this form are several fields that the user can enter data into to conduct a search of the db to retrieve relevant records.
The criteria I need to use should be something like..
Code:
Like "*" & [Forms]![Navigation Form]![NavigationSubform]![Navigationsubform]![Search Call-backs]![Surname] & "*"
I have tried opening the form directly rather than via the subform and using
Code:
Like "*" & [Forms]![Search Call-backs]![Surname] & "*"
If I try amending the path (incase I got it wrong!) by removing one of the NavigationSubforms, or adding another one, it acts as a parameter asking me for that field...
Any help would be appreciated!