I am having a similar issue. I have a database for organizations my organization interacts with. Part of the information we collect is the services offered by each organization. The idea is that if someone calls the organization for services we do not offer, we can look up who in our orbit we can refer them to. This information is stored in Check boxes. I am trying to create is a form where the user can check off the services they are looking for and have a query bring up all the organizations that offer each service. Basically what you describe in your Multi-feild search form tutorial, but using check boxes rather than text boxes. Do you have anything that covers this? Thank you!
Reply from Richard Rost:
The techniques covered in the Search Seminar will show you how to do this. We use several different methods, and the "build an SQL recordsource" will allow you to EASILY accomplish this goal.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.