Access date field - TechRepublic
General discussion
October 13, 2004 at 01:53 PM
joemede

Access date field

by joemede . Updated 21 years, 8 months ago

I have a table with 3 fields.
DateSubmitted
Status
DateClosed

DateSubmitted is set to date/time now()
Status has a drop down box to choose “Open” or “Closed”
How can I have the DateClosed field filled to current date/time based on choosing “Closed” from the status field?

I’m new to this so I’d appreciate any help,
Thanks, Joe

This discussion is locked

All Comments