View Full Version : SECOND REQUEST - Someone PLEEEEAASE HELP!


SGT_Sweety
05-11-2001, 04:41 AM
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
05-11-2001, 06:13 AM
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.