• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • Last Modified:

MS Access 2.0 multi select combo box

Do you know of code that I can use in 2.0 to make a combo box a multi select.  I Want the user to be able to pick as many states as needed for criteria for a report.
0
cremick
Asked:
cremick
1 Solution
 
ramromconsultant Commented:
Multiselect applies to ListBox, and was introduced after Access 2. You can simulate it by adding a column to the list that shows either blank or X, and toggle that value when user clicks the row. If you base the list on a table you'll have to add a 1 char text field to the table, and update the table to make the X show. If you base the list on a query you'll have to add a 1 char text field to a table in the query that is one-one with the list box rows. After updating the table you may also have to requery the list.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now