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]

Re: multi selection

kevcar40 wrote:[color=blue]
> 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
>[/color]

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

--
Smartin

[MacDermott]

Re: multi selection

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

"kevcar40" <kevcar40@btint ernet.com> wrote in message
news:1130606576 .812404.231740@ g49g2000cwa.goo glegroups.com.. .[color=blue]
> 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
>[/color]

[pietlinden@hotmail.com]

Re: multi selection

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]

Re: multi selection

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