A bit of information I'm not seeing: In your ticketing form, how is it getting the specific employee information that the ticket relates to. For example, is the employee selected from a combo box on that form, is the employee id a hidden field on the form, etc.?

Knowing how the employee information is accessed in that form tells us how best to populate the textbox you're looking for.

Hi Donald,
I have created a Combo Box that gets it's information from the Employee Information Table.
I also have tried a second method; a Query based on the Employee Information Table, and a Combo Box that gets in formation from that Query.

Ok,if you have a query that pulls all the information from the employee table, the simplest method would be in the query designer (QBE) add your table that holds your the text values of your "IsActive" field and make sure that there is a relationship line in the QBE from the Employee table (isActive field) to the Status/Helper table (ID field) and then add the field in your status table as a column in the employee combo box. You don't need to show it, but having it there will make things much easier.

For example, if your columns are: EmployeeT.EmployeeID, EmployeeT.EmployeeName then add StatusT.Description. In your form, in the properties for your combo box, you have column count =3 and maybe column widths: 0";1.5";0"

Then, the control source for your textbox would be "=ComboBox.Column(2)"

This way, anytime the combo box changes, the status would update to the new employee.

*** NOTE:  Change field, table, and control names to match your application.

That worked!!!
Thank you Donald!!!

happy to help