Multiple Search Criteria Form

[J77TDC]

Hi Guys

I've trawled Google for hours trying to find a simple answer to my issue but no joy so I thought it time to ask the experts!

I am working with a large database (around 270,000 clients) with multiple tables and would like to be able to create a form where non access users can easily extract mailing lists dependent on certain criteria.

The database is stuctured so that there is a table for client contact info then various linked tables with other information, e.g. subject of interest, geographical location by country etc etc. Contacts are regularly linked to multiple locations and areas of interest.

What I would like to do is to create a form where users can select multiple countries and areas of interests from a list box and click a button to 'get results'.

This in theory sounds simple enough but I am having serious mental block issues!!

I have designed the form and assigned several 'quick access' buttons to enable them to extract pre-defined criteria eg: all assigned to Africa etc but want to go a step further so that they can retrieve what ever data they wish to see.

I'm not asking for someone to do this for me, merely to point me in the right direction of where I begin. I love using Access and really want to learn more!!

Many thanks in advance for any help you are willing to offer!

[pbaldy]

This tutorial and sample db demonstrate one method:

http://www.baldyweb.com/BuildSQL.htm

To add a multi-select listbox you could adapt the loop used here:

http://www.baldyweb.com/multiselect.htm

[J77TDC]

Excellent, thanks for the quick reply. I shall go and have a play!

[pbaldy]

No problem, and welcome to the site by the way! Post back if you get stuck.