Hi, im still working with these query-by-forms. I've got it working and things are running pretty good. One little thing is my description field has multiple words in it, and the QBF only does a search for the FIRST WORD in the field. Is there a way I can open up the following command to all the words in my description field?:
[Taken from http://support.microsoft.com/kb/304428]
Like Forms!FormName!ControlName & "*" Or _
Forms!FormName!ControlName Is Null
This criteria statement is the same as the QBF sample above, except that you can query by using a wildcard. For example, if you enter "Jo" in a field by using this criteria statement, the query returns every record in the field that begins with "Jo." This includes Johnson, Jones, Johanna, and so on.