Using a Default Date that can be altered.

[bundymick]

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

[RuralGuy]

Assuming you are using a bound form then you could use the Current Event of the form to set the default value of the Date2 control.

[bundymick]

As a Novis, I'm not overly sure how this is done.. Sorry

[RuralGuy]

In the Current Event you would put something like:
If IsEmpty(Me.Date2) Then
Me.Date2 = Me.Date1
End If
...using your values of course.