Place text from recordset in Combo rather than linking to recordset
To link a textfield to a recordset:
Code:
set txtText.DataSource = rsSource
txtText.DataField = "Field"
To place the data in the textbox without linking:
Code:
txtText.Text = rsSource!Field
So what's the equivalent with a combobox. To link the combobox:
Code:
Set cboCust.DataSource = QteHrdRS
Set cboCust.RowSource = CustRS
With cboCust
.DataField = "Customer"
.ListField = "Name"
.BoundColumn = "CustNumber"
End With
So how can I just place the text in the combo box without linking it? I don't think I can as I still need it to have the .listfield option.