Hello everyone.
I just learned how to put combo boxes in tables by reading forum posts and watching YouTube videos. However, after doing all of the necessary steps in design view, it does not work (I understand that many Access programmers recommend against putting combo boxes in tables, but for now I need to get this figured out).
I created two tables just to experiment with: Table1 and Employees.
Table 1 simply has 2 fields. The first field is a primary key with an auto number. The 2nd field has the combo box and is supposed to let the user select the employee name from the Employees table.
Row source for the combo box: SELECT [EMPLOYEEID], [LAST NAME] FROM EMPLOYEES ORDER BY [LAST NAME];
The bound column is 1 which is the primary key.
The column count is 2
Now the weird part about this is that I am using a template that has a table with a combo box that works. When I try to mimic this same table design on a different table, it does not work.
When I open up Table1 (my experiment table) in datasheet view, I click the drop down arrow, and a window pops up asking me to enter the parameter value for the last name.
So why does it work for the other table and not the one I created? The combo box properties are identical. I can't figure out what I'm doing wrong.
Thanks in advance for the help!
Jessica