Me.Filter with dates

[ppataki]

Dear All,

I have a form where I have a text box where I can enter dates (me.aktkezdet_combo)
After entering a date I have put the below code in the AfterUpdate event of the text box:

Me.Filter = "aktkezdete >= " & Format(Me.aktkezdet_combo, "\#mm\/dd\/yyyy\#")
Me.FilterOn = True

(aktkezdete is a date field containing dates in the form)
When I enter a date I got a popup window saying "Enter parameter value" - aktkezdete

Could you please advise?
Many thanks

 

[vbaInet]

That error simply means aktkezdete is not the correct name of a field in the Record Source. Check that it exists.

 

[ppataki]

Hello,

Yes it exists
(PFA screenshot)

 

[vbaInet]

That is the name of the textbox. What is the name of the field? Click on the Data tab and look in the Control Source property.

 

[ppataki]

Point taken, it works now!!
Many thanks for your help, really appreciate it

 

[vbaInet]

You're welcome!

 

[Galaxiom]

The image shows there is a textbox with that name but what is the name of the field to which it is bound (the RecordSource property in the Data tab).

The filter is applied to the field in the Recordset not the control on the form.