K
Ken Schwartz
I have one form bound to table A. On that form is a multiselect list box
that is bound to lookup table B. When the user saves the contents of the
form, record(s) are stored in table C with the record id from table A and the
record id of the selected entry(ies) in the listbox that relate to table B.
Not a problem. What I want to do now is reverse this. When a record from
table A is selected, I want to programmatically show in the list box which
items were selected the last time the record was saved. I have no problem
getting a recordset of the items from table C, but how do I update the
listbox to show these items as selected?
that is bound to lookup table B. When the user saves the contents of the
form, record(s) are stored in table C with the record id from table A and the
record id of the selected entry(ies) in the listbox that relate to table B.
Not a problem. What I want to do now is reverse this. When a record from
table A is selected, I want to programmatically show in the list box which
items were selected the last time the record was saved. I have no problem
getting a recordset of the items from table C, but how do I update the
listbox to show these items as selected?