Update a field in table based on tickbox on form

[jo15765]

I have a tickbox on my form, it is unticked by default. If this tickbox is ticked, I want it to update a field in the table with todays date. How would I go about accomplishing this?



EDIT ---
Maybe it will make sense if I elaborate more. I have a tickbox for "Ordered" if it is checked then the part has been ordered, if it has not been checked of course the part has not been ordered. What I am wanting to do is update Date_Ordered with the date that the tickbox for Ordered was checked.

[TG_W]

Try the coding below to the AfterUpdate for the tickbox.

If Me!Ordered = True Then
Me.Date_Ordered = "Date()"
Else
Me.Date_Ordered = ""
End If

If it enters Date() into the field or returns an error, remove the "" from around Date().

[jo15765]

I just needed to use Date(). Thank you! One other question...We add the part to the database when we find out it needs to be ordered (but not yet ordered) and then we just click the arrow at the bottom of the form to add the record. Is there a way to capture the Date() it was added?

[TG_W]

Set Default Value of the field to Date(). That should do the trick.

[jo15765]

That got it again! Thank you for the prompt responses

[TG_W]

You're welcome. Glad I could help.