Hi,
I'm new to vba/macros in access. I have a main form that is built from scratch with fields from different tables and I have a search filter on it. When the search filter populates an employee, I want to be able to add a new record (case ID) for that employee. I've tried different codes for the add record button, but it either doesn't work or it just adds a new record to the form entirely and "clears out" the employee that is filtered (see screenshot below). There are also 3 other subforms on the mainform that need to have the new id to populate. I am able to get the save button, other navigation buttons to work on the main form as it should. I just don't know how to do the add record for a specific employee that is being searched. How can I do this?
I'm new to vba/macros in access. I have a main form that is built from scratch with fields from different tables and I have a search filter on it. When the search filter populates an employee, I want to be able to add a new record (case ID) for that employee. I've tried different codes for the add record button, but it either doesn't work or it just adds a new record to the form entirely and "clears out" the employee that is filtered (see screenshot below). There are also 3 other subforms on the mainform that need to have the new id to populate. I am able to get the save button, other navigation buttons to work on the main form as it should. I just don't know how to do the add record for a specific employee that is being searched. How can I do this?