multiple selections

[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

 

[Sandra Daigle]

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

 

[Newbie]

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

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

 

[Sandra Daigle]

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

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

 

[Newbie]

Thanks for your help

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

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