Solved

MS Access 2.0 multi select combo box

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

809 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