C
chriske911
why do I get this error when I am debugging the code
but it does work in the compiled version
although...
sometimes it doesn't work from the 1st click
this is the code; (thnx to Wayne Morgan)
If Me.Filter <> "" Then
Me.Filter = Me.Filter & " And [depot]='" & [Depot] & "'"
Else
DoCmd.ApplyFilter , "[depot]='" & [Depot] & "'"
End If
grtz
but it does work in the compiled version
although...
sometimes it doesn't work from the 1st click
this is the code; (thnx to Wayne Morgan)
If Me.Filter <> "" Then
Me.Filter = Me.Filter & " And [depot]='" & [Depot] & "'"
Else
DoCmd.ApplyFilter , "[depot]='" & [Depot] & "'"
End If
grtz