How to display a list box with select items in edit mode

[Vinod]

Hi All,

Here is my requirement,

I've a bound form to edit existed records from a table whiich contains free
text boxes and some list boxes (multi selection). During opening a form I'm
assigning list box items through query which reads from master table. Once
the list is populated I should highlight list boxes with existed data for the
same field from recored source i.e., A,B,C,D,E,F are list items and record
source for the same field from form source query/table is A;D;F. In this
situation list items A,D and F should heighlight.

When ever user clicks on 'Update' button then only all the updated fields
should store in record where it has picked, if it is list box then each
selected item should be stored by seperating with semicolon ( only.

Please provide your suggessions and thoughts which will be appreciated.

Advanced Thanks
Vinod

 

[TonyT]

Hi Vinod,

See the 'Selected Property Example' in help for sample code in how to
iterate thru items in a listbox. You can use
'ctlSource.Selected(intCurrentRow) = True' to select the rows that contain
the data you want.

hth

TonyT..