• Home
 · 
• Miscellaneous
 · 
• A one line call to populate either a combo box or a list box with the results of a recordset genera

A one line call to populate either a combo box or a list box with the results of a recordset genera

A one line call to populate either a combo box or a list box with the results of a recordset generated by an SQL call. I've tested this with

Rate A one line call to populate either a combo box or a list box with the results of a recordset genera

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

                        Rs.MoveLast
                        Rs.MoveFirst
                        Do While Not Rs.EOF
                           ctlControl.AddItem Rs(0)
                           Rs.MoveNext
                        Loop
End Sub

From your program, just say:   Call PopulateRs(RecordsetName, List1) or
Call PopulateRs(RecordsetName, Combo1)