Hi Helpers
I am a MS Access numpty that needs to find out how I can use a multi select list box as the basis of the criteria used in a select query. I have a list box on a form from which users will select a number of options. Each selection will be placed into an “In (…” list within the “Where Clause” for a field called “Sport Type” (i.e. “Football”, “Cricket”, etc). I guess that this is a fairly basic task for the experts, but I must stress that I have a diminutive degree of competence. Sorry!!!
Can anyone please help me?
Many thanks in advance.
DixieDean
I am a MS Access numpty that needs to find out how I can use a multi select list box as the basis of the criteria used in a select query. I have a list box on a form from which users will select a number of options. Each selection will be placed into an “In (…” list within the “Where Clause” for a field called “Sport Type” (i.e. “Football”, “Cricket”, etc). I guess that this is a fairly basic task for the experts, but I must stress that I have a diminutive degree of competence. Sorry!!!
Can anyone please help me?
Many thanks in advance.
DixieDean