List Box Criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ant - 20 Mar 2006 19:40 GMT

I have an unbound list box with the multi Select properties set to ‘Extended’.
One of the fields in the list box is a unique Number field [Group_ID]. I
would like to create a query that is based on the lines selected in the list
box. E.g. If Group ID 2, 5 & 6 are selected then the query will show 2, 5 &
6. Can any one help with the syntax of what I need to enter on the criteria
line of the query?

Thanks

Reply to this Message

Ken Snell (MVP) - 20 Mar 2006 21:13 GMT

I have a sample database that shows how you can create SQL queries for use
in reports by using the values in various controls on a form. You can look
at that to see how to create SQL queries.

Take a look at the database and then post back with questions:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

Signature

Ken Snell
<MS ACCESS MVP>

>I have an unbound list box with the multi Select properties set to
>'Extended'. One of the fields in the list box is a unique Number field
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Ant - 20 Mar 2006 22:18 GMT

Very Useful

Cheers
Tony Snell

>I have a sample database that shows how you can create SQL queries for use
> in reports by using the values in various controls on a form. You can look
[quoted text clipped - 11 lines]
>>
>> Thanks

Reply to this Message

Tom Ellison - 20 Mar 2006 22:17 GMT

Nepotism?

Tom Ellison

> Very Useful
>
[quoted text clipped - 17 lines]
>>>
>>> Thanks

Reply to this Message

Ken Snell (MVP) - 20 Mar 2006 22:58 GMT

Nope! < grin >

Signature

Ken Snell
<MS ACCESS MVP>

> Nepotism?
>
[quoted text clipped - 22 lines]
>>>>
>>>> Thanks

Reply to this Message