multiple selections

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Hi,

I have a list box: lbxArea and I have a query that selects all records
where a print flag = 'Y'

I would like this query to return all records where the PrintFlag = 'Y' and
the Area = the values selected in the listbox.

I know how to do this for a single entry by just setting the criteria to =
forms!frmname!lbxArea but haven't got a clue for the query to take account
of multiple selections in the listbox.

Any help greatly appreciated
 
Thanks for this. Do you know if there is a limit to the no of items you can
select at any one time? If yes, what is it.

Thanks again
Sandra Daigle said:
You have to write some code to do this. Take a look at the following
articles:

Take a look at the following articles -

http://www.mvps.org/access/forms/frm0007.htm

How to Use a Multi-Select List Box to Filter a Form
http://support.microsoft.com/default.aspx?scid=kb;[LN];135546


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hi,

I have a list box: lbxArea and I have a query that selects all
records where a print flag = 'Y'

I would like this query to return all records where the PrintFlag =
'Y' and the Area = the values selected in the listbox.

I know how to do this for a single entry by just setting the criteria
to = forms!frmname!lbxArea but haven't got a clue for the query to
take account of multiple selections in the listbox.

Any help greatly appreciated
Click to expand...
Click to expand...
 
There is no limit (well technically the max number is the number of items in
the list of course).

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Thanks for this. Do you know if there is a limit to the no of items
you can select at any one time? If yes, what is it.

Thanks again
Sandra Daigle said:
You have to write some code to do this. Take a look at the following
articles:

Take a look at the following articles -

http://www.mvps.org/access/forms/frm0007.htm

How to Use a Multi-Select List Box to Filter a Form
http://support.microsoft.com/default.aspx?scid=kb;[LN];135546


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hi,

I have a list box: lbxArea and I have a query that selects all
records where a print flag = 'Y'

I would like this query to return all records where the PrintFlag =
'Y' and the Area = the values selected in the listbox.

I know how to do this for a single entry by just setting the
criteria to = forms!frmname!lbxArea but haven't got a clue for the
query to take account of multiple selections in the listbox.

Any help greatly appreciated
Click to expand...
Click to expand...
Click to expand...
 
Thanks for your help
Sandra Daigle said:
There is no limit (well technically the max number is the number of items in
the list of course).

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Thanks for this. Do you know if there is a limit to the no of items
you can select at any one time? If yes, what is it.

Thanks again
Sandra Daigle said:
You have to write some code to do this. Take a look at the following
articles:

Take a look at the following articles -

http://www.mvps.org/access/forms/frm0007.htm

How to Use a Multi-Select List Box to Filter a Form
http://support.microsoft.com/default.aspx?scid=kb;[LN];135546


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Newbie wrote:
Hi,

I have a list box: lbxArea and I have a query that selects all
records where a print flag = 'Y'

I would like this query to return all records where the PrintFlag =
'Y' and the Area = the values selected in the listbox.

I know how to do this for a single entry by just setting the
criteria to = forms!frmname!lbxArea but haven't got a clue for the
query to take account of multiple selections in the listbox.

Any help greatly appreciated
Click to expand...
Click to expand...
Click to expand...
 
Back
Top