How to select Multi-selection box question

[Tom Lee]

Hi Guys,

I have two tables, table A and table B.
I would like to acheive Table A is one to many relationship with table
B, where is related by [Key].
I have created a form (bound to A) and a multi selectable list box
(unbounded) and I am able to sucessfully use SQL to insert selection
into B.

** The question**
When I tried to open form A again, I fail to able to select the
appropriate items in [on current] method. Can someone post a simple
code on how to do that?
Thanks a lot~

Thanks,

Tom Lee

[Pieter Linden]

Tom,
not sure I follow. So, you have something like this (right?):

FormA
mslbx [rowsource: tblB]

SubformB [rowsource: tblB]

and you want to have all the listed items in SubformB selected in the
unbound listbox? Can't you add them to the ItemsSelected collection
using a For Next loop?
there's code that loops through a MSLBX at www.mvps.org in the forms
section... just lookup "multi-select listbox"