Can you please advise how it is possible to display the value of a text box to displayed in a combo box.
I have a form called frmAuditors which contains amongst others, a combo box called cboCSRLookup and a text box called txtWindowsID.
The combo box has is populated from a table called tblAuditor which contains four fields with the bound field being the first column [ID] field. The combo box actually displays the value in the Auditor Name field.
I have used the following dlookup to obtain the ID number from the tblAuditor table.
CSR = Dlookup("[ID]", "tblAuditor", "[WinID] = '" & me.txtWindowsID& "'")
The above dlookup provides the ID number which can be used to corresponded with the ID field that the combo box is bound to.
Can you please advise how it is possible, to display the in the combo box, the Auditor Name that is based on the ID value obtained from the above aforementioned dlookup? Alternatively, if there are any other or better methods of obtaining the required result, your advice would be much appreciated.
Just as a quick example: If I input into the text box MXTHOM, this string value has an associated Auditor table ID value of 20. This ID value will be available to the combo box via the row source. So the objective is to pass the ID value of 20 to the combo box and the combo box will then display the associated string value (item) MXTHOM.
Thanks in advance.