I am working on a database in Access 2000 and I want to display a value in text box based on the option that is selected in a combo box. Specifically, an employee number is picked from the combo box, and I want to display the employee's first and last name in the text box. The employee ID, first and last name are all stored in one table with the employee ID as the primary key, and the second table will contain the employee ID multiple times along with other information.
I have tried setting the control source in the text box to the employee ID selected in the combo box and then set the default value to the employee first name & employee last name, but only the first name appears. The default value seems to make no difference in what appears because I can put anything in the default value, and only the first name will appear.
I imagine the solution is not particularly difficult, but I haven't really done much database creation and I don't have a clue where to go from here.
Lincoln
I have tried setting the control source in the text box to the employee ID selected in the combo box and then set the default value to the employee first name & employee last name, but only the first name appears. The default value seems to make no difference in what appears because I can put anything in the default value, and only the first name will appear.
I imagine the solution is not particularly difficult, but I haven't really done much database creation and I don't have a clue where to go from here.
Lincoln