By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Tick Box

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.