Populate values from previously selected list box values on another form
Posted on 2006-11-03
I have multiple list boxes where people can select one to many fields that correspond to a record.
These selections in the list boxes are moved to another table where they are referenced with the record.
The problem I have is when I go back into that record either on the same form or another the list box is cleared.
I have had to create subforms within my forms to display the data and allow it to be updated.
Is there a way to have the selections on my list boxes populated when a user opens a particular record without creating subforms?
Below is an example of one of my list boxes code to send it to a table.
Private Sub cmdOK_Click()
Dim rsTrain As DAO.Recordset
Dim varTrain As Variant
Set rsTrain = CurrentDb.OpenRecordset("tblTrainingEmployee", dbOpenDynaset)
For Each varTrain In Me.lstTraining.ItemsSelected
!TrainingType = Me.lstTraining.ItemData(varTrain)
!EMP_ID = Me.EMP_ID