One field form based query w/ list on sub-form; almost there, help!!

[mfleysher]

I have Form01 with subform Form02.

I have TextBox01, and on AfterUpdate, it commands a requery for FormB.

I have Query01, with 3 fields, Field01, Field02, Field03; then I have another field which is MadeField01: [Field01] & " " & [Field02] & " " & [Field03];

Then, Query02 presents the results of Query01, and in the criteria for MadeField01, I have the following:

Like "*" & [Forms]![Form01]![TextBox01] & "*" or [Forms]![Form01]![TextBox01] is null


HOWEVER...

I need the search to deliminate(?) TextBox01 and search each term presented in TextBox01.

E.g.,

TextBox01.Value: Test Searching Name

and I want the query to not search "Test Searching Name" but to search "Test" then "Searching" then "Name" and return results for any records with either term matching.


Please, help!!

Mark