ON 20070814@9:46:10 AM at page:
http://www.piclist.com/techref/language/asp/vbs/vbscript/65.htm#38004.7825810185
Flak  DiNenno[FD-GLIC-RB9] Replied to post 38004.7825810185 by jheryer

|Insert 'J-

I believe this is because since Access 97, you can't update/reference default value/data in a field from another field in that table.  Not sure if it works in referencing fields in another table?

The work-around would be something like this.

1. Create 3 fields in your table, for:
      a. [Strike Date]
      b. [Purchase Date]
      c. 'DateDifference' - the difference between a & b (where the DateDiff result will be stored)

2. Place bound controls on your form for all 3 fields
3. Set the AfterUpdate events for both the [Strike Date] & [Purchase Date] to run a procedure and place the following code in that procedure:

  DateDifference=DateDiff("d",[Strike Date],[Purchase Date])

Hope that helps.
-Flak' at: '<!-- 38004.7825810185 EOR -->'

<A TITLE="65.26.69.118" NAME="38004.7825810185" HREF="mailto:jheryer@kc.rr.com">jheryer@kc.rr.com</A>
    asks:
    <BLOCKQUOTE>
      I am setting a Default Value in Microsoft Access to =DateDiff("d",[Strike
      Date],[Purchase Date]) where Strike Date &amp; Purchase Date are Field names
      in the table. I get an Access error message "could not find field 'Strike
      Date'."
    </BLOCKQUOTE>