Hi! I am good with Excel but I have very little Access experience and I have inherited an Access file that I need to update. We use the Access file as a ticketing system, to allow employees to go in and create "work tickets" for a department using a User Form.
I need to update the Employees Table so that when people go to submit a ticket, and they click on the drop down box for "Created By" that they see an up-to-date list of our employees. The list is currently very out of date. I can go in to the table and add a new employee easily enough. My issue is that I want to remove employees that no longer work for us from the possibilities in the "Created By" drop down list, however I don't want to delete them from the Employees table because for historical purposes I may need to see who the creator of an old ticket was, and it could of course, be an employee that no longer works with us.
So I need a solution to edit the Employees table in a way that leaves everyone in the table, yet also allows me to indicate on a record that they are no longer an active employee, and exclude them from the "Created By" drop down list since they don't work for us anymore. For example, could I add a column to my Employees table called "Status" and then make everyone either "Active" or "Inactive" and then somehow tell the combo box to only display people with a Status of "Active"?
Can anyone tell me how to accomplish this?
Thanks in advance!
Spacle