In need of help regarding combo box coding and button coding (Access form project)

no code needed, just queries.
Your cboDept gets IT selected, then triggers AFTERUPATE event. This updates the cboEmps based on cboDept
The query in cboEmp, looks at the cboDept as a filter, so the query "qsEmpsByDept" looks like:
select [emp] from tEmployees where [dept]= forms!frmEntry!cboDept

Then must be refreshed when the cboDept changes...

sub cboDept_afterupdate()
   cboDept.requery
end sub

As for time entry, user enters the times into a table.
you run a query that sums the time (up to 40), qsRegTimeSum
and another query that sums > 40, qsOvertimeSum

Thank you for your reply.

My issue has been solved using the afterupdate queries.