-
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
-
Feb 10th, 2018, 06:13 PM
#2
Re: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field
Welcome to VBForums
Thread moved from the 'Database Development' forum (which is for questions about table design/SQL/etc) to the 'Office Development/VBA' forum (which is where VBA and other Access based questions belong)
-
Feb 13th, 2018, 11:11 AM
#3
Re: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field
Post the code you are using for this.
-
Feb 14th, 2018, 06:48 AM
#4
Re: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field
When you say 'macro' you are on about access macro or vba code?
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
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
|