.Filter like syntax error

[InfernoJaffa]

Hi Guys

I have managed to get this working:

Private Sub FilterLoc1_Click()
With Me.[DS].Form
.Filter = "Serial = ""1.5"""
.FilterOn = True
End With

I would like to change the code to look for a like statement of "1.*" but have not managed to get my attempts to work.

Any help is appreciated.

 

[Grumm]

have you tried

.Filter = "Serial Like '1.*'"

this should work with wildcard characters.

 

[InfernoJaffa]

have you tried

.Filter = "Serial Like '1.*'"

this should work with wildcard characters.

Bingo!

Thank you.