I have a form that I would like to display the long description of a lookup value. For example I have a form that has a procedure code field as a combo box where the drop-down box displays records from another table to choose from. The combo box has 2 columns the procedure code and it's long description. After selecting the procedure code (which is then saved in the field) I want to display the long description on the form for viewing purposes only. I created a text box on the form where AfterUpdate I make that field "Me.ProcDesc = Me.txtProc.Column(1)" which works but as you move through existing records I also had to place the same code "Me.ProcDesc = Me.txtProc.Column(1)" on the Form_Current so it keeps refreshing to what the current records long description should be as you move through the records.
My issue is that it's on a subform and causes the code to repeatedly be accessed when the main form is loading and makes the form longer to load or even move through the records. The main form is not specifically tied to one data source. The data source is created from the user selecting certain criteria so it is filtered to just the specific records they choose.
Is there any way to have that field refresh with the associated long description without having to reference it from Column(1) of the combo box?
Hope this makes sense. I am maintaining an old application and it's been a while since I've actually had to program any changes to it. Any suggestions would be appreciated