Link to home
Start Free TrialLog in
Avatar of dcmennealy
dcmennealy

asked on

Insert Today's date in one field based on the value of another

I have a tracking database and I want to make it so that when the person marks the "status" field "completed" it inputs today's date in the "datecompleted" field.  How do I do this in my form?
ASKER CERTIFIED SOLUTION
Avatar of ErezMor
ErezMor
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dcmennealy
dcmennealy

ASKER

Thanks, it worked!
I am new to VBA and this was very simple and useful
you are most welcome to ask further