Unanswered: Display fields based on Combobox selection
I created a Combobox that lists 3 fields EmpID,Firstname,Surname, from an Employee table. When user selects a record, the EmpID is stored in the field - OK so far. Is there a way I can also display (read only) the Firstname, Surname? Ideally, I will display these beneath EmpID. Therefore, essentially, I want to retrieve 3 separate fields from the Employee table based on one user selection.
Thanks for replying. I inserted the code you suggested in the "After update" property of the combobox but nothing happened i.e. text box remained blank. The combobox is on a subform. Is "Me." the right thing to use? Excuse my ignorance, but I'm a newbie with access!