Auto Insert Date by Ticking Check Box?

N

Neil

Hi there, i have a tick box in my form called:

resolved_tick_box

I want to have it so that when i tick this box, it inserts the current date
into my text box, called:

txtSelectDate

Im a coding novice, and just getting into this, so if possible, tread
carefuly ;) -thanks alot,

Neil
 
M

Michel Walsh

Hi,


Under its onClick event procedure, add code like:



Me.NameOfTheTextBoxToBeUpdated = Now( )




That's it. The keyword Me is not required, but typing it, intellisence
should kick in, where you should be able to locate the text box name...
avoiding typo error..




Hoping it may help,
Vanderghast, Access MVP
 
Top