I
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Displaying Multi-Selections in Access97 Form
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Displaying Multi-Selections in Access97 Form
- This topic has 5 replies, 2 voices, and was last updated 24 years, 5 months ago.
Viewing 0 reply threadsAuthorReplies-
WScharlotte
AskWoody LoungerDecember 30, 2000 at 4:40 pm #508653Are you trying to display selections that were written into a record when that record is current? If so, whether you can or not depends on how you saved the data.
You’re going to have to provide a lot more information in order to get a useful answer. What is the rowsource for the listbox or boxes? How are the selected items stored? How does the program know which data was originally selected? What does “originally created” mean in this context?
-
WSPaul
AskWoody LoungerDecember 30, 2000 at 9:51 pm #508657O.K. Here’s more description of what I’m trying to do.
On the data entry form the multi-select list boxes are like this:
Unbound list box Name: lstNames
Row Source: qryPersonnel (names and unique numbers)They appear on a form where an incident is being recorded and the incident has a unique number, which is the link to the list boxes.
The data is written into a table containing the incident number and the number of each individual involved (tblPersonnelByIncident, containing intIncident and intPersonnel) with an append query. So for each incident there are as many records containing two numbers (incident and person) as there are personnel involved.
In edit mode, I want the form to appear much as it does in add mode, but with the data filled in, of course. That means the individuals selected in add mode should show as selected when the list box appears. How do I read the records in the table and somehow
-
WScharlotte
AskWoody LoungerDecember 31, 2000 at 4:38 pm #508680OK, let me make sure I understand. Your listbox is unbound but you want to display the items that have been selected for the record if they open the form again or navigate off that record and then back, is that right? If that’s the case, you could write a function to retrieve the keys for the records that were selected as an array and then in the current event of the form, loop through that array and use it to set the selected property of the items. However, if you have set only the selected property, the listbox won’t reflect those items in the value. You’ll also need code to clear the listbox when the user moves to a new record.
Multiselect listboxes are input controls, so they aren’t designed to allow easy display. What I usually do is add a textbox or a second listbox and display a concatenated list of values selected in it, kind of like a pick list. But does your form allow them to remove a previously selected employee from the list? That would require still more code to handle. And if they add more selections to that record, you have to decide how you want to handle it.
-
WSPaul
AskWoody LoungerDecember 31, 2000 at 7:51 pm #508683O.K. That helps. I like the idea of a second listbox to display the list of values selected. What I had thought of doing for changes was to provide a change button. From that I’d reset the list, delete the records from the table, then get the new list of selections and put them into the table.
Come to think of it, I’ve seen forms that give the pick list and display the resulting picks in another listbox. That’s an idea that should work here.
Thanks for your suggestions. If I can work out the code for building and using that array of keys, I think that I can figure out the rest of it.
Paul
-
WScharlotte
AskWoody Lounger
-
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Discover the Best AI Tools for Everything
by
Alex5723
1 hour, 13 minutes ago -
Edge Seems To Be Gaining Weight
by
bbearren
3 hours, 31 minutes ago -
Rufus is available from the MSFT Store
by
PL1
12 hours, 11 minutes ago -
Microsoft : Ending USB-C® Port Confusion
by
Alex5723
14 hours, 20 minutes ago -
KB5061768 update for Intel vPro processor
by
drmark
13 minutes ago -
Outlook 365 classic has exhausted all shared resources
by
drmark
12 hours, 31 minutes ago -
My Simple Word 2010 Macro Is Not Working
by
mbennett555
10 hours, 6 minutes ago -
Office gets current release
by
Susan Bradley
12 hours, 43 minutes ago -
FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers
by
Alex5723
2 days, 2 hours ago -
Windows AI Local Only no NPU required!
by
RetiredGeek
1 day, 11 hours ago -
Stop the OneDrive defaults
by
CWBillow
2 days, 3 hours ago -
Windows 11 Insider Preview build 27868 released to Canary
by
joep517
2 days, 13 hours ago -
X Suspends Encrypted DMs
by
Alex5723
2 days, 15 hours ago -
WSJ : My Robot and Me AI generated movie
by
Alex5723
2 days, 16 hours ago -
Botnet hacks 9,000+ ASUS routers to add persistent SSH backdoor
by
Alex5723
2 days, 16 hours ago -
OpenAI model sabotages shutdown code
by
Cybertooth
2 days, 17 hours ago -
Backup and access old e-mails after company e-mail address is terminated
by
M W Leijendekker
2 days, 5 hours ago -
Enabling Secureboot
by
ITguy
2 days, 12 hours ago -
Windows hosting exposes additional bugs
by
Susan Bradley
3 days, 1 hour ago -
No more rounded corners??
by
CWBillow
2 days, 20 hours ago -
Android 15 and IPV6
by
Win7and10
2 days, 10 hours ago -
KB5058405 might fail to install with recovery error 0xc0000098 in ACPI.sys
by
Susan Bradley
3 days, 13 hours ago -
T-Mobile’s T-Life App has a “Screen Recording Tool” Turned on
by
Alex5723
3 days, 16 hours ago -
Windows 11 Insider Preview Build 26100.4202 (24H2) released to Release Preview
by
joep517
3 days, 10 hours ago -
Windows Update orchestration platform to update all software
by
Alex5723
3 days, 23 hours ago -
May preview updates
by
Susan Bradley
3 days, 10 hours ago -
Microsoft releases KB5061977 Windows 11 24H2, Server 2025 emergency out of band
by
Alex5723
3 days, 2 hours ago -
Just got this pop-up page while browsing
by
Alex5723
3 days, 15 hours ago -
KB5058379 / KB 5061768 Failures
by
crown
3 days, 12 hours ago -
Windows 10 23H2 Good to Update to ?
by
jkitc
2 days, 14 hours ago
Recent blog posts
Key Links
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.