Hi
I have a MS Word User Form with a listbox, how do i populate it with rows of data (from access) with 2 columns - i know how to/can do it with 1 column... i.e.
Set oRecordSet = oDatabase.OpenRecordset("Customers"
'add company names to lbExistingCustomers listbox
With oRecordSet
Do While Not .EOF
ExistingCustomers.lbExistingCustomers.AddItem .Fields("CompanyName"
.Value
.MoveNext
Loop
.Close
End With
then later refer to the 1st columns value of a selected row.
Cheers
-Martin
I have a MS Word User Form with a listbox, how do i populate it with rows of data (from access) with 2 columns - i know how to/can do it with 1 column... i.e.
Set oRecordSet = oDatabase.OpenRecordset("Customers"
'add company names to lbExistingCustomers listbox
With oRecordSet
Do While Not .EOF
ExistingCustomers.lbExistingCustomers.AddItem .Fields("CompanyName"
.MoveNext
Loop
.Close
End With
then later refer to the 1st columns value of a selected row.
Cheers
-Martin