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!

 

[Pat Hartman]

What is the purpose of the checkbox? Once it's set dies it stay set? Is the print date stored somewhere?

It seems to me, that if you want the date printed to show on the report when it is printed, you would just add an unbound control to the report with a ControlSource of
=Date()

If you want to save in the database the date the report was printed, then we need to be clear whether you want to keep only the FIRST date, the most recent date, or every date.

 

[Mark_F]

Thanks. I solved it like this,

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