Multiple field query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chellie P - 24 Jul 2006 18:54 GMT

I'm fairly new at using Access. I've got myself stuck on something that I
think should be fairly easy. Here goes my example . . . a form containing
several list boxes--one box has Grocery Store A, Grocery Store B, Grocery
Store C. Another has apples, oranges, milk, bread, etc. I would like to
choose Grocery Store B as well as apples and oranges and have those records
open on click of a command button. I'm struggling finding the best way to do
this.
--

Reply to this Message

Duane Hookom - 24 Jul 2006 19:23 GMT

What do you mean by "have those records open on click of a command button"?
Do you have a form or report you are attempting to open?

Signature

Duane Hookom
MS Access MVP

> I'm fairly new at using Access. I've got myself stuck on something that I
> think should be fairly easy. Here goes my example . . . a form containing
[quoted text clipped - 5 lines]
> do
> this.

Reply to this Message

Chellie P - 24 Jul 2006 19:30 GMT

Well, I'd like to run a query based on the items being selected.

Signature

Chellie

> What do you mean by "have those records open on click of a command button"?
> Do you have a form or report you are attempting to open?
[quoted text clipped - 8 lines]
> > do
> > this.

Reply to this Message

Duane Hookom - 24 Jul 2006 22:29 GMT

I have a generic function for use with multi-select list boxes in queries at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Signature

Duane Hookom
MS Access MVP

> Well, I'd like to run a query based on the items being selected.
>
[quoted text clipped - 16 lines]
>> > do
>> > this.

Reply to this Message

Chellie P - 25 Jul 2006 15:42 GMT

Thank you!!!!

Signature

Chellie

> I have a generic function for use with multi-select list boxes in queries at
> http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
[quoted text clipped - 19 lines]
> >> > do
> >> > this.

Reply to this Message