-
Feb 9th, 2018, 12:15 PM
#1
Thread Starter
New Member
[Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field
Hi all,
I am having trouble getting a date field in a table to auto fill when a certain status is chosen from a combo box within a form. Specifically, I have a field called "Status" (Combo Box) in a form and one called "Closed Date" (Date/Time) in a table and want today's date to fill when the Status is changed to "Closed". I have been perusing several forums and threads, and have not been able to pinpoint this specific issue. All that I have been able to do is create a macro that populates the date when any status is chosen from the "Status" combo box. The macro has an Action of "SetValue", and under the Argument: Item is [Closed Date], and Expression is Date(). I cannot get it specified to only fill when the status is changed to "Closed". Any help would be greatly appreciated!
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|