Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Closed Thread
 
Thread Tools Rate Thread Display Modes
Old 09-05-2016, 06:37 AM   #1
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,024
Thanks: 40
Thanked 3,578 Times in 3,456 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
multi select form

Responding to a thread where I suggest using a multiselect listbox, I thought it would be useful to upload this simple example where you can turn a form into a multi select form. It only does a 'simple' version but with more work could probably also be extended to mimic the extended form.

The principle is simple, the form requires two unbound textboxes, the first (called Select) runs some code to populate the second (SelectedList) with the uniqueID's for the selected records. Then conditional formatting is used if the uniqueID for each record is in the 'list'.

This example has a third unbound textbox to act as a row background which is also conditionally formatted.

The filter button has code that applies the selected list to the filter. Obviously other code to do other things such as send a report, open other forms etc could go here instead.

I use the pipe (|) as separator since it is not used in normal spelling
Attached Files
File Type: zip multiselectform.zip (44.1 KB, 1227 views)

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline  
The Following 4 Users Say Thank You to CJ_London For This Useful Post:
luzz (02-06-2018), NauticalGent (09-05-2016), rgwfly (11-09-2016), Suresh_Murugan (11-13-2017)
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
multi select list box in a form mveda2004 Forms 1 03-06-2013 09:10 AM
Cannot add to a multi-select form Djblois Forms 2 03-26-2010 06:53 AM
Multi select List Box on Form Barry1903 Forms 1 12-17-2009 08:07 AM
Multi-Select Form ckeezer Forms 1 11-30-2005 08:46 PM
Multi Select Field on Form MiAs Forms 6 11-15-2004 11:06 AM




All times are GMT -8. The time now is 01:33 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World