General query

HOJU15

Registered User.
Local time
Today, 07:44
Joined
Feb 7, 2003
Messages
12
I want to search the entire table to for a parameter

i.e. there is a field with data PC 12-10Dr 46-48-5W5M

if I type in pc 12-10 in the form it should return the record above but its not.??
Here is the criteria I used
when I use the criteria like"pc 12-10*" it works but not when I use the form as below

Like "[FORMS].[GENERAL]*[GENERAL]"
 
Like "*" & [FORMS]![GENERAL]![GENERAL] & "*"
 

Users who are viewing this thread

Back
Top Bottom