By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,708 Members | 1,473 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,708 IT Pros & Developers. It's quick & easy.

How to select Multi-selection box question

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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"
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.