I have am building a form to populate the table tbl_timeclock
In this form a user will enter the work hours for several employees. The employees come from the table tbl_userlist. This table has 2 fields:
-USER ID
-Deptarment
I want to make a form to update the tbl_timeclock, at the top of the form a user will select a USER ID from a combo box, but I want the choice of USER ID to be filtered based on a second combo box, "Department". This way the person filling the form will select the deptartment from a Drop Down/Combo Box first, have a narrow choice of employees based on that selection.
New to Access, tried messing around with this and coudn't figure it out.
thanks for help in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks