Link to home
Start Free TrialLog in
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?
Avatar of Markus Fischer
Markus Fischer
Flag of Switzerland image

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
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial