check box issue, need help...

[vividor]

I have a report that is going to present some information related to vacations days.

I am using a check box, I want the check box to check marked itself if the day requested is the same as todays day.

in other words, If ([day req]) = Now() then check box will check marked itself..
Is any way to do this intructions to the check box field?

 

[sambo]

If Me.dayReq = Date() Then
  Me.chkBoxName = -1  'Set Check Box To True
End If

 

[vividor]

Thank Sambo, this is exactly what I need..
but where do I put the code?

 

[sambo]

Put the code in the After Update <Event Procedure> of your dateReq TextBox