Can someone please see something obvious I'm obviously doing wrong somewhere but spent the last 4 damn hours trying to resolve.
I have a form - "Search_Input_Form"
containing a field - "SearchMe"
I want to run the contents of what is put into that field through a query which searches a field of my data table.
In the criteria of the field I want searching for this string I have put:
Like "*[Forms]![Search_Input_Form]![SearchMe]*"
This doesn't work. I have even created an output form which puts in the above reference as a field to prove that the string is being 'passed through' the system, ie that that reference is correct.
The problem may lie elsewhere, but for the moment, can anyone see anything wrong with this criteria?
I'm pulling my hair out and going bald very quickly.
I have a form - "Search_Input_Form"
containing a field - "SearchMe"
I want to run the contents of what is put into that field through a query which searches a field of my data table.
In the criteria of the field I want searching for this string I have put:
Like "*[Forms]![Search_Input_Form]![SearchMe]*"
This doesn't work. I have even created an output form which puts in the above reference as a field to prove that the string is being 'passed through' the system, ie that that reference is correct.
The problem may lie elsewhere, but for the moment, can anyone see anything wrong with this criteria?
I'm pulling my hair out and going bald very quickly.
