Multi Select List Box Trouble

[Subwind]

I have written a small database to help with planning on a web game.



What I am after is a code to allow more than 1 selection per list box.

Ally Tribe Selection filters both Ally Continent Selection and Ally Player Selection (same as the enemy boxes).

Because of the amount of data in the front end tables, these are then used to create a new table with only the filtered data, to the run the calcs.

Would anyone be able to maybe take a look and/or advise me on the best way to filter the list boxes?



I did manage to get a working multi select option, which passed the selections to a text box fine, but failed when passing to the make table query.

~Matt

[June7]

I would suggest not creating new table each time, just deleting records from existing table and repopulating with new records from the listbox selections.

[Subwind]

I have a working code for this now. And it filters the other list boxes too. I shall post the code in here later.

~Matt