[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MS Access 2.0 multi select combo box

Posted on 1998-02-08
1
Medium Priority
?
462 Views
Last Modified: 2008-03-10
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
Comment
Question by:cremick
1 Comment
 
LVL 17

Accepted Solution

by:
ramrom earned 200 total points
ID: 1967900
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Course of the Month18 days, 10 hours left to enroll

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question