Hello folks!
I have a form that I use to enter employee late arrivals. The employee name on the form is a combo box that is bound to a table that the information goes to, and the employee name in the table is bound to a query which finds active employees, and the in the table the employee name field is limited to the employee name field in the active employee query. The active employee query gets information from and employee master table.
Long story short (too late) the combo box is limited to what is in the employee name field in the active employee query. I just added a new employee and need to put information into this table, but while I can see the employee is on the active employee query, I cannot choose them from the combo box on the form, nor can I choose or enter them onto the late arrival table itself.
What have I screwed up and how do I fix it?
Thanks!