Multiple Criteria Coding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All,

Hopefully someone can help me here...I have an unbound form and 14 unbound
text boxes which I am using to search a table for data. I have been told the
best way to go about this is to create a string and then apply the string to
the recordset. I have no idea on how to do this. Currently, I am using
temporary tables to conduct my searches and they tend to bloat the database.
The searches are also beginning to take a long time as the database is
increasing in size. I'm looking for some help in creating the code that
would create a string of all my text boxes and then apply the string to the
recordset...The following is some info regarding my unbound form...Could
someone please gimme some sample code and/or possibly steer me in the right
direction......

form: frmSearch
table: tblOccurrence
textboxes: txtCriteria1 through to txtCriteria14

Once again, any help would be GREATLY appreciated :)

Regards
 
What is the relationship between your txtCriteria and the table? Is each
one a different Or condition on the same field, or does each one relate to a
different column? It's hard to help you with such limited information.

-Amy
 
please don't post the same question separately in multiple newsgroups. if
you feel the need to post in more than one newsgroup (it's rarely
necessary), then cross-post. that means creating one message and addressing
it to both newsgroups - just like sending one email to multiple recipients
at the same time.

your question was answered in the microsoft.public.access newsgroup, under
heading Multiple Search Criteria - VB.
 
Amy, each txtCriteria on the unbound form relates to a different column in
the table...Hope this helps..

Regards,
 
Back
Top