Design Question

[RonL]

In the link given look at the section of the OnCurrent code that begins "for icount = .... ". and ends with "Next iCount ".


That's a loop. I was suggesting for you to build something similar but instead of elongating a string, include the appropriate code to update [event] each time there's a pass that contains a selected [client] Sorry, no time to elaborate. Perhaps someone will provide code. Also, can never hurt to study up on VBA techniques, particularly looping through recordsets.


good luck, Ron

[roarcrm]

Thanks...

The code I currently have is:

Private Sub Command25_Click()

Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("Session")
With rst
     .AddNew
     .Fields("ClientID") = ClientCombo.Value
     .Fields("Date") = Date.Value
     .Fields("Duration") = Duration.Value
     .Fields("SessionType") = Session.Value
     .Fields("Officer") = Officer.Value
     .Fields("Comment") = Comment.Value
     .Update
 End With
 DoCmd.Close acForm, "Log Session", acSaveYes
End Sub

The client ID is a combo box where they select one client and it's added to the table. If this was changed to allow multiple selections can someone help me to change that code?

Thanks.