468,539 Members | 1,480 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,539 developers. It's quick & easy.

multi value field in textbox of a form

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.
  • 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?

Jun 4 '10 #1
0 1102

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by rudranee | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.