Automatic Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If you have two fields Approved (Yes/No) and Date can the date be controled
when you enter a Yes in the approved field or if you have =Now() and the
deflaut will it always put a date in when you open the datebase? Is there a
way to may the date only fill in when the Yes is indicated? Thanks...
 
I think you are asking how to only populate a date if/when someone checks Yes.

You would want to use the AfterUpdateEvent, of the Yes/No control, that when
Yes is selected it posts the date to the table.

Sharkbyte
 
Back
Top