Extra record added to Filter result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top