Solved

MS Access 2.0 multi select combo box

Posted on 1998-02-08
1
450 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

695 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