Tick Box

[G]

I have this field which is called "Statement Sent". It is a tick box.
There is another field called "Statement Sent Date". Its a date field.

How can I have the current date automatically populate the "Statement Sent
Date" field once the "Statement Sent" tick box is ticked.

Would it require an expression in the query ? Or a VB expression (which
I'm not that great in ).
Any assistance would be appreciated.

[Allen Browne]

You could use the AfterUpdate event procdeure or the check box in your form
to assign the date:

Private Sub Statement_Sent_AfterUpdate
If Me![Statement Sent] = True Then
Me![Statement Sent Date] = Date
Else
Me![Statement Sent Date] = Null
End If
End Sub

I'm not really clear on why you would have both. Could you just use the
Statement Sent Date field, and assume that it's not sent if no date is
entered? Or are there really occasions where you need to record that the
statement was sent even when you don't know when?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"G" <sk**@optusnet.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...

I have this field which is called "Statement Sent". It is a tick box.
There is another field called "Statement Sent Date". Its a date field.

How can I have the current date automatically populate the "Statement Sent
Date" field once the "Statement Sent" tick box is ticked.

Would it require an expression in the query ? Or a VB expression (which
I'm not that great in ).
Any assistance would be appreciated.