Form - Free Text Search

[kevsim]

Kevsim
I have a form based on a query. How do I go about setting up a "Free Text" search function for one or more fields on the form. Do I need a dropbox to select the field I require to search? I would require to view all results of the search and what controls are necessary and the coding required. Would I need forward and backward buttons? When I am completed with the search how do I leave the query. I would appreciate any advise.
kevsim

 

[afloyd]

set the criteria of the query to the fields that want as criteria. For each field of the query that you are search on use the following -

= [forms]![form1]![textbox]

if you need to trap for spelling errors you can wildcard your search to LIKE "*" & [forms]![form1]![textbox] & "*"

-HTH

 

[kevsim]

Afloyd, thank you for the info, I am still a little lost on setting up the controls and code, I may not have explained fully, the full explanation is as follows -
I have a form based on a query. At present I search for records using 4 combo boxes, I select data in the first box, from my selection in this box only relevant data appears in the second combo box, from the selection in the second combo box only relevant data appears in the third combo box, when I make a selection from the fourth combo box, the complete record appears on my form filling all controls. How do I go about setting up a "Free Text" search function to achieve the same thing for one or more fields on the form and finish with the complete record? Do I need a combo box to select the field I require to search, if so, what code goes in the box for selecting the field? How does this choose only records relevant to the search? I would require to view all results of the search and what controls are necessary and the coding required. Would I need forward and backward buttons? When I am completed with the search how do I leave the query. I would appreciate any advise.
kevsim