B
Bill
Good day all
I'm trying to populate a list menu (Combo Box) with the results from a
query. The thing is I want the combo box to display the ID and Discription
but I need to use the ID as the value form submitting the form. I have a
value of 2 in the Column count and I'm trying to assign the value like so:
cboProjectIdDivision.Column(0).RowSource = projID
cboProjectIdDivision.Column(1).RowSource = projDescription
without any joy.
Any pointers here would be greatly appreciated.
Bill
I'm trying to populate a list menu (Combo Box) with the results from a
query. The thing is I want the combo box to display the ID and Discription
but I need to use the ID as the value form submitting the form. I have a
value of 2 in the Column count and I'm trying to assign the value like so:
cboProjectIdDivision.Column(0).RowSource = projID
cboProjectIdDivision.Column(1).RowSource = projDescription
without any joy.
Any pointers here would be greatly appreciated.
Bill