Checkbox = date

[Mark_F]

Hi guys.
I need to use a check box on a form that will save the date on the report. How can I do that?

 

[Minty]

In Access Date() will always give you today's date so set your control to that.
Me.Mycontrol = Date()

 

[theDBguy]

Also, you save data in tables. You just use reports to display them. Cheers!

 

[Mark_F]

I have a hidden text box on the form which will hold the date once the checkbox is checked. The text box will will show the date on the report.

 

[Mark_F]

I have the checkbox and text box on the table.

Also, you save data in tables. You just use reports to display them. Cheers!

 

[Mark_F]

Thanks. I solved it like this,

If me fridge = true then
[At fridge date] = now()
Else
[At fridge date = ""
End if