Apply Filter with 2 conditions

[JonnyArcher]

Hello all

I want to apply a filter after update of a combo box that restricts records to the name selected in the combo box and also only shows uncompleted records, I've tried stuff like

Private Sub Original_Caller_Name_AfterUpdate()
Dim myname As Variant
Filter = ""
   FilterOn = False
   myname = Me.Original_Caller_Name
   DoCmd.ApplyFilter , "Me.Completed_Record = False" And "me.Original_Caller_Name = myname"
   End Sub

But I can't get the syntax right and can't find any useful help from MS (surprise)


Any help would be gratefully accepted

 

[Mile-O-Phile]

Private Sub Original_Caller_Name_AfterUpdate()
   Dim strMyName As String
   Me.Filter = ""
   Me.FilterOn = False
   strMyName = Me.Original_Caller_Name
   DoCmd.ApplyFilter, "Me.Completed_Record = False AND Me.Original_Caller_Name = """ & strMyName & """"
   End Sub