Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Unanswered: Using a Default Date that can be altered.

    The Database I am currently running has multiple date fields. I want a particular date field to default to another date unless a specific date is entered.

    EG if Date2 field is empty use date1.

    I have a formula which is based on date2

    Neither of these dates are current dates and fall anytime 13 weeks+ in the the past.

    ta

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so you need to place some code behind the form to handle this

    probably the best location is going to be the control holding date1 value and use its after update event. this even will fire after changes are made to the value in that control

    your code is going to be something like
    Code:
    if isnull(date2control) then 'test if the control holding date2 is null/empty 
      date2controld.value = date1control.value 'and if so set date2 to be the same as date1
    endif
    you will need to replace datexcontrol with the names of the controls you are actually using
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •