Lets say I have two tables, one for transactions, and another table who's primary key is the foreign key in the first table, and this relationship simply associates locations to transactions.
I have a form with a list box that shows all the potential locations, so that the user can open some dashboard forms that only pertain to a given location. So I know how to pass the data from the selection to the dashboard, however I would now like the user to have the capability to select multiple locations from the first list.
so if I use a SQL statement the WHERE clause is like
.... WHERE LocationID = " & me.lstLocations.value & ";"
but how would I equate this type of method to selecting multiple choices? I am sure there is some type of loop that escapes me.
Thanks Justin