Searching a field on a record [HELP]

[eduardo]

Hello,



I have a form with many fields, one of them called "CUSTOMER NAME", that contains their full name.

The problem is the following, I need to be able to search any words independently whether they are separate or not.

Example, Customer name: JACKSON ROSE, JACOB STEVEN

Is there any way I can search for "JACKSON JACOB" and get this match: JACKSON ROSE, JACOB STEVEN ?

Thank you very match for any help.

[June7]

Not exactly.

You can use query with wildcard criteria: Like "*" & Forms!formname!controlname & "*"

Then enter JAC as the search criteria.