hello i have a problem thats probably easily solvable...i just cant seem to pull it together. i have an employee table where employees have their own employee id number. i have 3 other tables which have information on certain employee id numbers. in a form, i have a combo box for employee id number and labels for the other info out of the tables. i need to select an employee id from the combo box and have the multiple tables put their information into the form....can anyone help...thank you very much...
linking combo boxes...
- Thread starter j6niner
- Start date
Hey j6niner,
I think I'm following what you want to do. If you have the employeeID in all the tables that contain the values that you want. You could go to the combo boxes Row Source property and build the query behind that combo box using all the tables involved and use the EmployeeID to build the relationship between the tables. Then add the fields that have the values you want to the grid below.
After that on your form you can reference the column number of the combo box for the values you want. Example would be in you need employee name in a unbound text box and it's in the second column from the left. Then in the text box control source you could put:
=Forms![MainFormName]![ComboBoxName].Column(1)
HTH
Shane
I think I'm following what you want to do. If you have the employeeID in all the tables that contain the values that you want. You could go to the combo boxes Row Source property and build the query behind that combo box using all the tables involved and use the EmployeeID to build the relationship between the tables. Then add the fields that have the values you want to the grid below.
After that on your form you can reference the column number of the combo box for the values you want. Example would be in you need employee name in a unbound text box and it's in the second column from the left. Then in the text box control source you could put:
=Forms![MainFormName]![ComboBoxName].Column(1)
HTH
Shane
Similar threads
