Extra record added to Filter result

[Dick Holm]

MS Access 200
I have a form with a cmb (Provider) in the header and two bound text boxes in detail (not a subform). Each time a new value is selected in the cmb I apply a filter as shown below

Private Sub Provider_AfterUpdate(
Me.Filter = "ProviderID = " & Forms("Caseload")!Provide
Me.FilterOn = Tru
End Su

The detail section shows all the records I want PLUS the selected record from the previous set. Help.
thanks, Dick

 

[Dick Holm]

Found the root cause, it is changing the record in the database when I make a new selection in the cmb (pairing the last selected detail with the newly selected cmb entry). Now all I have to do is figure out the right way to do this.