Hold Filter on Subform

[acarterczyz]

If the change no longer exists in the subform, I cannot export those changes easily. My goal is the manager will reassign in the subform, click a button, and it will email me the changes so I can deal with it on my end.

 

[vbaInet]

We're going round in circles here. I've already told you what needs to be done.

If you want to export the changes, you simply change the filter.

 

[acarterczyz]

We're going round in circles here. I've already told you what needs to be done.

If you want to export the changes, you simply change the filter.

I changed the filter to what you had suggested before:

       strFilter = "[Rep Number] = " & Me.RepNumberField & "'" & _
                " AND " & "[UserName] = '" & Me.UserNameField & "'"
        RepReassignmentSubform.Form.FilterOn = True

This does not stop the filter from "refiltering" data as its changed.

 

[vbaInet]

I later mentioned that you need to create a query that includes all employees both former and current and this query will now become the Record Source of your form.

With the new dataset:
1. when the form is initially opened you'll filter it down to display the ex-employee that's assigned to the Manager
2. After assignment, the filter will be change to include the new employee and the ex-employee
3. If you want to export just the new employee, change the filter again to reflect this.