newbee2
Technical User
- Apr 21, 2002
- 85
- 0
- 0
Hi,
Through a macro call up a query when I select a button on the switchboard. This query acts as an initial search feature.
There is a feild called key_Words, where words are typed as markers to distinguish what is on the form record.
I am trying to get the query to look at this feild on the form and thru parameters in the criterea select three possible words in that feild and return the result.The resulting records can be filtered some more as normal from the filter button on the task bar. Lots of forms with key_words and wishing to search for particular forms that statisfy criteria.
How do I go about setting up the criteria for the parameter or is there a search function I can automate to do something like google or the search function for tektips for a database but I want it to run like a query because I figure thats what selects best.
Or have I confused eveyone including myself.
Ta,
Bill
Through a macro call up a query when I select a button on the switchboard. This query acts as an initial search feature.
There is a feild called key_Words, where words are typed as markers to distinguish what is on the form record.
I am trying to get the query to look at this feild on the form and thru parameters in the criterea select three possible words in that feild and return the result.The resulting records can be filtered some more as normal from the filter button on the task bar. Lots of forms with key_words and wishing to search for particular forms that statisfy criteria.
How do I go about setting up the criteria for the parameter or is there a search function I can automate to do something like google or the search function for tektips for a database but I want it to run like a query because I figure thats what selects best.
Or have I confused eveyone including myself.
Ta,
Bill
