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]"
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]"