MS Access: passing value from combo box to text box
Posted on 2009-04-07
This should be a straightforward question, but I am having trouble figuring it out.
I have a single-record form based on one table. I put an unbound combo box on the form (in the details section) that pulls its values from the same table:
SELECT tblBorrowInquiries.BorrowerInquiryID, tblBorrowInquiries.BorrowerName FROM tblBorrowInquiries;
I want the combo box to pass the value selected by the user to a text box (txtBorrowerInquiryID which has as its control source BorrowerInquiryID) and thus change the record displayed. I used the following in the after-update of the combo box:
Me.txtBorrowerInquiryID.Value = Me.cboBorrowerInquirySelect.Value
Needless to say, I am getting the runtime error 2448 when I try to select a new record in my combo box and can't change the text box. I had this working, but must have changed something.