Looking for a way to make a form that...

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Folks,

I'm looking for a way to make a form where there is a list box allowing
multiple selections, but also where when the user returns to the record, the
list box will update to show which items have been selected. The source for
the list will be a table in another database (that could have
additions/deletions independant of the app where the form would reside)
joined to a local table that stores the selection values.

I've seen the knowledgebase article that deals with multiple selection list
boxes, but it wasn't clear how to "preselect" items when the box opens...

Anyone have any ideas, or somewhere to point me to figure out how to do
this?

Thanks!
 
Use a subform for the related selections instead of a list box.

It is just not worth the effort to parse the data from a non-normalized
delimited text field, and loop through the listbox items to set the selected
values in the form's Current event, and then check them all and write it
back to the text field whenever the user selects another item in the list
box or before allowing the user to leave the current record, and also handle
the form's Undo event so that it resets the list box values based on the
OldValue of the delimited text field.
 
Back
Top