text box tied to check box

's Computer Specifications

Hello all,
I would appreciate a little help. I have a sub-form with a
check box titled "Corrected", when the user checks this box I would
like to have the text box I have created "Date Corrected" autopopulate
with the current date and time. Thanks in Advance!

's Computer Specifications

(E-Mail Removed) wrote:
> I would appreciate a little help. I have a sub-form with a
>check box titled "Corrected", when the user checks this box I would
>like to have the text box I have created "Date Corrected" autopopulate
>with the current date and time.

The standard approach is to set the date in the check box's
AfterUpdate event procedure:

If Me.Corrected = True Then
Me.[Date Corrected] = Now
Else
Me.[Date Corrected] = Null
End If

--
Marsh
MVP [MS Access]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create a combo box that is tied to another combo box?	rosamaria	Microsoft Excel Worksheet Functions	2	9th Dec 2009 11:32 PM
Clear Text Box Tied to Combo Box?	GoBrowns!	Microsoft Access Form Coding	1	22nd Jul 2009 07:32 PM
Macros tied to Check Boxes in Excel	Barb Reinhardt	Microsoft Excel Programming	1	27th Jan 2009 08:24 PM
query tied to text box	Brennan	Microsoft Access Reports	5	29th May 2008 08:44 PM
Bound text box in a chart tied to parameter field in a query	Russ	Microsoft Access Reports	1	13th Feb 2004 05:25 PM