Hi there,
I would like to create a search form where a user can select a field which he wants to search through(from a combo box) and then enter a value for the search in a text box.
I could make a query for each field, but would prefer to create a query in my vba code and then output the results to a subform...
How would i go about this - what functions must i use in my VBA??
Any help is much appreciated.
D
I would like to create a search form where a user can select a field which he wants to search through(from a combo box) and then enter a value for the search in a text box.
I could make a query for each field, but would prefer to create a query in my vba code and then output the results to a subform...
How would i go about this - what functions must i use in my VBA??
Any help is much appreciated.
D
