Help!

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I've got a bit of a dilema I'm hoping someone can help me
with, please!

I have a form with a list box that is connected to a
similar field within a table (and they're related). On the
properties list box, the "Mult Select" option is set
to "Simple". However, when I make multiple selections (or
even a single selection) within that list box, the data
does NOT go into the table. How do I make multiple data
selections (or even a single selection) from that list box
on the form AND have the data go into the table's field?

Any guidance is greatly appreciated!

Thank you very much!
 
I use an unbound multi-select listbox and code the listbox's On Click event
to store all selected items in the textbox of my table. In one database, I
use a separate table to store nothing but the ID from the main table and the
items to be selected in the listbox so that it's easier to read from this
table in the form's On Current event to display which items were selected in
the record.
--
Karen Stern
A Little Help Computer Services, LLC
www.alittlehelp.net
(e-mail address removed)
518-885-4549
Everyone Needs A Little Help!
 
The other solution is to use a subform instead of a listbox. Create a table
of id's and the selection. The subform would use this table as the
recordsource and be linked to the main form by the id. Use a combo box to
limit the choices in the subform to the items you wanted in the listbox.
The subform would be either continuous forms or datasheet view and would
display all selected items for each record without additional coding.

--
Karen Stern
A Little Help Computer Services, LLC
www.alittlehelp.net
(e-mail address removed)
518-885-4549
Everyone Needs A Little Help!
 
Back
Top