Either My Forms are a bit 'THICK' or I'm doing something wrong?

[paulmcdonnell]

Hi kids!


I want my form to filter by date of a field - the date come froms an updated text box. It is this value that I'm trying to use as the filter criteria, after a click on a control...
I set a variable to be the date, included it in the filter criteria and now access keeps asking me what this criteria is...

Haven't I just told it...?

I'm using the code below:


Dim dat As Date

Me.[Text139] = ActiveXCtl134.Value
dat = Me.[Text139]
Debug.Print [Filter]
Me.FilterOn = False
Me.Filter = "App_date = dat"
Me.FilterOn = True
Me.Refresh


Hope you can help!!
Paul