I am pretty new to vba. This is what I am trying to achieve.
I have a form that onload displays all records in a form.
I also have a searchbox with a button that should be able to take multiple search criterias (from multiple colums in a table or query). And then a reset button to display records one more.
The search strings are the following fieldnames in a contacts table, they are all of dataytpe text.
The search ctiteria would be based on LIKE, and I guess OR between to seperate them.
Should I have strfilter variable where the different fieldvalues are concatenated in the same string?
Thanks
Sohail
I have a form that onload displays all records in a form.
I also have a searchbox with a button that should be able to take multiple search criterias (from multiple colums in a table or query). And then a reset button to display records one more.
The search strings are the following fieldnames in a contacts table, they are all of dataytpe text.
- LastName
- FirstName
- EmailAddress
The search ctiteria would be based on LIKE, and I guess OR between to seperate them.
Should I have strfilter variable where the different fieldvalues are concatenated in the same string?
Thanks
Sohail