Hi again.
I want to know, I have made a query and a form of that query. I am wanting to know, is there a way (I know, use the Form Load event) in VBA where you enter the the criteria to search for and it does the search? I know, it would be something like:
But after that input box, how can I tell it to tell the query to go do that search on the searchwhat variable? Is it possible?
I thought maybe u can do something like:
Query![query name]![Field]!
![Criteria] = searchwhat or something like that??
I want to know, I have made a query and a form of that query. I am wanting to know, is there a way (I know, use the Form Load event) in VBA where you enter the the criteria to search for and it does the search? I know, it would be something like:
Code:
sub form_load()
dim searchwhat as string
searchwhat = inputbox("What Customer number would you like to search for?")
But after that input box, how can I tell it to tell the query to go do that search on the searchwhat variable? Is it possible?
I thought maybe u can do something like:
Query![query name]![Field]!