On my main form I have a combo box and search button. The combo box is just a listing of employees and its data source is a simple employee table. Once a name is selected in the combo box the search button queries a table to get all of the results for that employee and the results are in the subform underneath. That works with no problem. My problem is I want the user to be able to edit all the fields in the subform however I have a field named "Assigned To" and that is the employee name that the user selected in the combobox. I want to be able to change that name but I only want to use the employee names in the combo box/employee table.
I feel like this is easy but i'm having a brain fart.
I feel like this is easy but i'm having a brain fart.