Listbox Question (1 Viewer)

[TheSearcher]

I have frm_NewClient which adds a new client to the database.
The controls are:
txt_Client_Id
txt_FirstName
txt_LastName
lst_Payers (This is a multiselect list box that displays different insurance carriers)

My insert query works perfectly. I am able to get the selected items from the listbox into my table.

However, I also have frm_UpdateClient which updates any client info. The controls are the same as on frm_NewClient.
My question: How do I show what payers were originally selected in my listbox? In other words, how do I show them as being selected in the listbox after my recordset returns all of the info?

Thanks in advance,
TS

 

[MajP]

Take a look at this demo. May help

Using multiple Options in Checkboxes to add records

Suppose my form looks like this Can I add records into the event table using multiple options in checkboxes like below : Or can I also use List Box to add records

www.access-programmers.co.uk

 

[TheSearcher]

Brilliant! Thank you very much!
I only had to use a very small snippet of code (see below). I did have to change SelectedID to string however. Also had to comment out the Exit For statement.

'****************************
  Dim varItm As Variant
  Dim SelectedID As String
  Dim i As Integer
 
  'loop the recordset
  Do While Not rs1b.EOF
    SelectedID = rs1b("Payer")
      
    For i = 0 To (lst_Payers.ListCount - 1)
       If lst_Payers.Column(0, i) = SelectedID Then
        lst_Payers.Selected(i) = True
        'Exit For
        End If
    Next i
    rs1b.MoveNext
  Loop
'**********************************************