Results 1 to 4 of 4
  1. #1
    clarkej is offline Novice
    Windows XP Access 97
    Join Date
    Nov 2010
    Posts
    12

    On change

    hey guys



    just a quick one need help with the wording not too sure how to structure it to work correctly

    i have two feilds on my form, and i want it to auto populate the date in the second one as soon as there is something entered into the first one.

    i now its a on Change, but not to sure how to work it

    cheers
    Jay

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You would use the AfterUpdate event of the 1st control.
    Me.OtherControlName = Date()

  3. #3
    clarkej is offline Novice
    Windows XP Access 97
    Join Date
    Nov 2010
    Posts
    12
    Brilliant THANK YOU!!!!!!!!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad we could help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combo box change
    By nawaray in forum Programming
    Replies: 4
    Last Post: 01-17-2011, 04:04 AM
  2. Using VBA to change VBA
    By Desstro in forum Programming
    Replies: 14
    Last Post: 11-13-2010, 05:17 PM
  3. Field Name Change
    By MelindaP in forum Forms
    Replies: 8
    Last Post: 07-01-2010, 12:03 PM
  4. Change DOB to age
    By denl10 in forum Access
    Replies: 2
    Last Post: 02-04-2010, 02:18 AM
  5. Name Change
    By skip17 in forum Access
    Replies: 0
    Last Post: 01-12-2009, 01:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums