Hello guys, i tried to filter a name of a client = David O' Sullivan
However is gives me an error, i think it is because of the aphostrophy
This is the code i am usingCode:Private Sub Combo77_AfterUpdate()Me.Filter = "(Display_Name) = '" & Me.[Combo77] & "'" Me.FilterOn = True
Thanks in advanced