I have a form with an DepartmentForm with a subform with employees who work in that department. I also have an EmployeeForm with a subform for departments (an employee can work for more than one department).
when I have the EmployeeForm open and delete a department that that particular employee works for, when I go back to the DepartmentForm, the subform listing for the employee which I've just removed has #deleted# in the textboxes of the subform. I have to go, for instance, look at another record or similar, for the subform to reflect the update.
I've tried DoCmd.Refresh and DoCmd.Requery in the OnFocus and OnActivate and OnLoad events but nothing works.
Both main forms remain open during the process. Can someone help with updating the subform?