Combox Filters!!!!!!!!!!!

[Neilster]

Hi Fella,

I have followed your advise code regarding Public filters and have set up a module as advised, however when I put the code in..

If Not IsNull(Me.NameFilterBox) Then
If Me.Form.Filter="" Then
Me.Form.Filter="Name ='" & Me.NameFilterBox & "'"
Else
Me.Form.Filter = Me.Form.Filter & " and Name = '" & Me.NameFilterBox & "'"
End If
End If

If Not IsNull(Me.LocationFilterBox) Then
If Me.Form.Filter="" Then
Me.Form.Filter="Location ='" & Me.LocationFilterBox & "'"
Else
Me.Form.Filter = Me.Form.Filter & " and Location = '" & Me.LocationFilterBox & "'"
End If
End If

After highlighting Me. It come up with a compile error saying :- Invalid use of Me keyword

I was wondering if you could cast some light on this?

Cheers:banghead: