Multiple selections from a list box?

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Hi,

I'm using a form to drive a query. Is it possible to make
more than one selection from a list box in the form that's
used to set criteria in a query?
For example, I have a list box that has choices like:
Owner
Publisher
Vice President

Would it be possible to select "Owner" and "Publisher"?

Thanks,

marc
 
Well,

I figured out how to select more than one choice in the
form, but the query does not work now. I have [form]!
[frmFormName]![ListBoxName] in the criteria line of the
query. When I had the list box "Multi Select" property set
to "None" the query worked. When I changed it to "Simple"
or "Extended" the query no longer worked.
Oh, yea, I'm in Access 2000.

Thanks,

marc
 
Take a look at http://www.mvps.org/access/forms/frm0007.htm at "The Access
Web"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Marc said:
Well,

I figured out how to select more than one choice in the
form, but the query does not work now. I have [form]!
[frmFormName]![ListBoxName] in the criteria line of the
query. When I had the list box "Multi Select" property set
to "None" the query worked. When I changed it to "Simple"
or "Extended" the query no longer worked.
Oh, yea, I'm in Access 2000.

Thanks,

marc
-----Original Message-----
Hi,

I'm using a form to drive a query. Is it possible to make
more than one selection from a list box in the form that's
used to set criteria in a query?
For example, I have a list box that has choices like:
Owner
Publisher
Vice President

Would it be possible to select "Owner" and "Publisher"?

Thanks,

marc
.
Click to expand...
Click to expand...
 
Thanks Doug,

Pardon my ignorance, but what does it mean by "manually
assign the complete WHERE clause..."?

Thanks,

Marc
-----Original Message-----
Take a look at
Click to expand...
http://www.mvps.org/access/forms/frm0007.htm at "The Access
Web"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Well,

I figured out how to select more than one choice in the
form, but the query does not work now. I have [form]!
[frmFormName]![ListBoxName] in the criteria line of the
query. When I had the list box "Multi Select" property set
to "None" the query worked. When I changed it to "Simple"
or "Extended" the query no longer worked.
Oh, yea, I'm in Access 2000.

Thanks,

marc
-----Original Message-----
Hi,

I'm using a form to drive a query. Is it possible to make
more than one selection from a list box in the form that's
used to set criteria in a query?
For example, I have a list box that has choices like:
Owner
Publisher
Vice President

Would it be possible to select "Owner" and "Publisher"?

Thanks,

marc
.
Click to expand...
Click to expand...


.
Click to expand...
 
Try taking a look at http://support.microsoft.com/?id=135546 to see whether
it helps more.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Marc said:
Thanks Doug,

Pardon my ignorance, but what does it mean by "manually
assign the complete WHERE clause..."?

Thanks,

Marc
-----Original Message-----
Take a look at
Click to expand...
http://www.mvps.org/access/forms/frm0007.htm at "The Access
Web"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Well,

I figured out how to select more than one choice in the
form, but the query does not work now. I have [form]!
[frmFormName]![ListBoxName] in the criteria line of the
query. When I had the list box "Multi Select" property set
to "None" the query worked. When I changed it to "Simple"
or "Extended" the query no longer worked.
Oh, yea, I'm in Access 2000.

Thanks,

marc

-----Original Message-----
Hi,

I'm using a form to drive a query. Is it possible to make
more than one selection from a list box in the form
that's
used to set criteria in a query?
For example, I have a list box that has choices like:
Owner
Publisher
Vice President

Would it be possible to select "Owner" and "Publisher"?

Thanks,

marc
.
Click to expand...


.
Click to expand...
Click to expand...
 
Hi Doug,

That worked for me!

Thanks,

Marc
-----Original Message-----
Try taking a look at http://support.microsoft.com/? id=135546 to see whether
it helps more.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Thanks Doug,

Pardon my ignorance, but what does it mean by "manually
assign the complete WHERE clause..."?

Thanks,

Marc
-----Original Message-----
Take a look at
Click to expand...
http://www.mvps.org/access/forms/frm0007.htm at "The Access
Web"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Well,

I figured out how to select more than one choice in the
form, but the query does not work now. I have [form]!
[frmFormName]![ListBoxName] in the criteria line of the
query. When I had the list box "Multi Select"
Click to expand...
property
set
to "None" the query worked. When I changed it to "Simple"
or "Extended" the query no longer worked.
Oh, yea, I'm in Access 2000.

Thanks,

marc

-----Original Message-----
Hi,

I'm using a form to drive a query. Is it possible to make
more than one selection from a list box in the form
that's
used to set criteria in a query?
For example, I have a list box that has choices like:
Owner
Publisher
Vice President

Would it be possible to select "Owner" and "Publisher"?

Thanks,

marc
.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top