[Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field-VBForums
Results 1 to 4 of 4

Thread: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2018
    Posts
    1

    Question [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

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    39,587

    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)

  3. #3
    Fanatic Member
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    982

    Re: [Access 2007 VBA] How To Autofill Date When Specific "Status" Is Chosen In Field

    Post the code you are using for this.

  4. #4
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Java (JSP) Hell!
    Posts
    5,233

    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?

    BOFH Now, BOFH Past, Information on duplicates

    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
  •  



Featured


Click Here to Expand Forum to Full Width