By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

multi selection

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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?

Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.