Solved

MS Access 2.0 multi select combo box

Posted on 1998-02-08
1
436 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 100 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

762 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now