Hi all:



I have a multi-select list box...The values of which are coming from  one

Table (eg. T1)....now the values I select in list box are stored in another

table(I am using Insert statement on event Lost focus)...T2....now when i

open the form again...My list box should highlight the values that i

selected earlier....What function/event or procedure do i use  before the

list box displays it's values...Do you have any sample code or idea on

this??



Cheers,

Ajay

I believe you can set the Selected(<indexnum>) property to true in code to

have this happen--for instance



   Me.lstMyListBox.Selected(13) = True



But you've got to know the index values of the choices & I'm not sure how to

get those...



FWIW, if you've got the space on your form, you can always put up a second

list box that displays the contents of your T2 table--that would let the

user know which options were selected & they wouldn't even have to scroll

around.



Cheers,



-Roy



-----Original Message-----

From: Ajay [mailto:yourkind2001@y...]

Sent: Wednesday, September 19, 2001 8:40 AM

To: Access

Cc: ajay_ndel@y...

Subject: [access] List Box





Hi all:



I have a multi-select list box...The values of which are coming from  one

Table (eg. T1)....now the values I select in list box are stored in another

table(I am using Insert statement on event Lost focus)...T2....now when i

open the form again...My list box should highlight the values that i

selected earlier....What function/event or procedure do i use  before the

list box displays it's values...Do you have any sample code or idea on

this??



Cheers,

Ajay