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