Results 1 to 4 of 4
  1. #1
    MSAccessOldTimer is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Posts
    46

    AutoFill Multiple Date Fields, but have Flexibility to Change Some Fields to Different Dates

    I have a form contains [Date1], [Date2], and [Date3] fields. 95% of the time these dates are all the same. About 5% of the time, [Date2] and/or [Date3] are changed to different dates. My user, who enters a lot of records on a daily basis, would like to have [Date2] and [Date3] auto fill to the date entered in [Date1] automatically, but then have the flexibility to change the dates in either [Date2] or [Date3], or both, to different dates. Just to clarify, the dates in [Date2] and [Date 3] could be different from each other, not just [Date1].



    Thanks in advance for any assistance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,515
    In the afterupdate event of date1,set the others,
    date2=date1
    date3=date1

  3. #3
    MSAccessOldTimer is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Posts
    46
    Thank you Ranman256. I will give that a try this weekend. First I have to do my "real" job!

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,702
    If you want to see this before the form is updated, try setting the default value 2 and 3 to = [Date1]
    I am presuming the controls and the form are bound.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-28-2018, 04:39 PM
  2. Replies: 6
    Last Post: 08-24-2018, 04:52 PM
  3. Replies: 1
    Last Post: 02-16-2013, 09:11 AM
  4. Replies: 12
    Last Post: 05-07-2012, 12:41 PM
  5. Replies: 5
    Last Post: 09-14-2010, 09:50 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