Fill with current time on check

[roccoau]

Hi,
I would like to insert the currrent time in a feild on my form once a checkbox is ticked.
Can anyone please help me with this.

Tks Rgds
Roc

 

[gemma-the-husky]

targetfield = now

'format the field as a time type to suit yourself

 

[roccoau]

thanks Gemma works great

 

[cross5900]

You can also do a quick OnClick vba code to do this as well.

If chkbox.value = true then
textbox.value = date() 'or whatever time function you need to use like Now() or etc.
else
textbox.value = "" 'to reset the time if you unclick
end if