Show only selected values from listbox on form (listbox from a table)

[STGE]

Hi

I have a form where I want to show all the selected values from a listbox bound to a query.

I have one table (tListboxValues) containing the values of the listbox with the fields ID and Values

I have another table (tVendors) in which there is a multiselect listbox linked to the the table tListboxValues (only listbox IDs is stored in tVendors).

Now on my form I want to put a listbox showing only the checked values form the table. How is this possible?

Is there a standard way to setup access to do this or do I have to write a macro to solve the problem?

I have tried a lot of different queries for this but cant seem to get it right. Is there anyone who can help me with this one?

Best regards
Stine

 

[Trevor G]

Microsoft provides a sample database for using forms and in there are some samples which will use list box and various other things, you will end up having to write some code to establish what has been selected from the list box

Look at this link

http://office.microsoft.com/en-us/a...t-you-can-download-and-adapt-HA001120138.aspx

 

[CEH]

Listbox based on query?... In query..Listbox Value, chkbox = True