Avatar of mtrussell
 asked on

Using a listbox in Access

I have a list box on a form and it is calling a list of names from a table.  What I want to do is click on the list of names and save those names to a table and when I open the form the list of names appears to be selected in the listbox and if I edit the list the latest names will appear to be highlighted.  In the table, I want the list of names to be comma delimited.

The listbox is called listbox11
the table is tbl_deliverables
the field in the table is development

Anyone can help me?
Microsoft Access

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon

Sine Access 2007, you can use a multi-value field, which does some of what you require. I prefer to have better control over the data. In the small attached demo, there is a field with a comma-separated list of colours chosen from a colour table. A pop-up edit form allows the selection from a list, just as you describe.

It's possible to include the list box directly on the main form, using the Form's Current event to keep it synchronized, but this would also require managing Undo, which becomes a bit more technical.

I hope this gets you started
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy