multi selection

[kevcar40]

Hi i have a form that has a number of options"buttons" on it 13 in all,

that is the number of posible areas.
if the user selects are 1 the data for area 1 is returned and so on for

each area.
What i want to know is it possible to filter the areas on more than one

selection(which could be variable)
e.g if area 1 selected return area 1 data
if area 2 selected return area 2 data
if area 1 & 2 selected return area 1 & 2 data
if area 1 & 5 selected return area 1 & 5 data
if area 2 & 5 selected return area 2 & 5 data etc...
also i have the option of returning each area
Can anyone point me in the right dirction please
thanks
kevin

[Smartin]

kevcar40 wrote:

Hi i have a form that has a number of options"buttons" on it 13 in all,

that is the number of posible areas.
if the user selects are 1 the data for area 1 is returned and so on for

each area.
What i want to know is it possible to filter the areas on more than one

selection(which could be variable)
e.g if area 1 selected return area 1 data
if area 2 selected return area 2 data
if area 1 & 2 selected return area 1 & 2 data
if area 1 & 5 selected return area 1 & 5 data
if area 2 & 5 selected return area 2 & 5 data etc...
also i have the option of returning each area
Can anyone point me in the right dirction please
thanks
kevin

How about one checkbox for each area, and one command button that
examines the state of each of the checkboxes?

--
Smartin

[MacDermott]

You might consider using a multi-select listbox instead of checkboxes.

"kevcar40" <ke******@btinternet.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Hi i have a form that has a number of options"buttons" on it 13 in all,

that is the number of posible areas.
if the user selects are 1 the data for area 1 is returned and so on for

each area.
What i want to know is it possible to filter the areas on more than one

selection(which could be variable)
e.g if area 1 selected return area 1 data
if area 2 selected return area 2 data
if area 1 & 2 selected return area 1 & 2 data
if area 1 & 5 selected return area 1 & 5 data
if area 2 & 5 selected return area 2 & 5 data etc...
also i have the option of returning each area
Can anyone point me in the right dirction please
thanks
kevin

[pietlinden]

there's code at www.mvps.org/access for using a multi-select listbox to
gather query criteria...

What are you going to do with this? Filter a form or report?

[kevcar40]

thanks all for replies
in answer to Smartin i currently have check boxes for each area
problem is it is not working correctly the code is
"WHERE All_Areas.Area='" & Me.a1hold & " ' " & _
"OR All_Areas.Area='" & Me.a2hold & " ' " & _
"OR All_Areas.Area='" & Me.A3hold & " ' " & _
"OR All_Areas.Area='" & Me.A4hold & " ' " & _

this will run correctly if there is only two areas this however when
more areas are added continually returns A1 and A2
List boxes i have never used then so i dont fully understand the
workings of then

the result could go to a form then printed as a report

thanks again all

kevin