Form filters Aghhh! (1 Viewer)

[paulmcdonnell]

Forgive my ignorance but all I'm trying to do is filter a form using the dates on my continuous form being equal to a text box (which has teaken a date from a CALENDAR). I use this

Private Sub Command141_Click()
Me.[Text139] = ActiveXCtl134.Value
Me.Filter = "App_date = [Text139]"
Me.FilterOn = True
End Sub

Obviously this isn't working but any Gurus out there who know how I have to change this?

Many thanks
Paul

 

[Jon Holmes]

Paul,
Try
Me.Filter = "App_Date = #" & ActiveXCtl134.Value & "#"
Jon