SECOND REQUEST - Someone PLEEEEAASE HELP! (1 Viewer)

S

SGT_Sweety

Guest
Trying to input [DateAuthorized] - a hidden, auto-fill field on a form, based on condition anyone of two "yes/no" fields are checked "yes". Form view is "continuous" and built from a query. No matter what I do, I cannot get the field to fill. Using Input Mask: "99/99/00;0" and Default Value: "=Now()"
 

charityg

Registered User.
Local time
Today, 08:38
Joined
Apr 17, 2001
Messages
634
in the afterupdate event of both check boxes type the following code using the name of the appropriate checkbox
if checkname=-1 then
dateauthorized=format(now(),"mm/dd/yyyy")
endif
this will update the date field in the form anytime the boxes are checked.
 

Users who are viewing this thread

Top Bottom