This is my first time using Multi combo box.
I have a table named Vendor with a Multi combo box.
Data is
Vendor
How do I reference the numbers.
Function ShowControls()
Dim o As DAO.Recordset
Dim MyVendor1 As Variant
Set o = CurrentDb.OpenRecordset("Vendor")
MyVendor1 = o![Vendor Numbers 1]
qrySQLItems = "(((TblTeradata.Vendor) In (" & MyVendor1 & "))"
End Function
I have a table named Vendor with a Multi combo box.
Data is
Vendor
AP Numbers 1 |
---|
12003, 1240, 1561, 2296, 2308, 2693, 31198, 3257, 3913, 42716, 48628, 49589, 54329, 9506 |
Function ShowControls()
Dim o As DAO.Recordset
Dim MyVendor1 As Variant
Set o = CurrentDb.OpenRecordset("Vendor")
MyVendor1 = o![Vendor Numbers 1]
qrySQLItems = "(((TblTeradata.Vendor) In (" & MyVendor1 & "))"
End Function