Results 1 to 1 of 1
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Cant Assign a Value To This Date Field

    I have a bound control named StartDate on my form and on the OnLoad Event I am trying to use this code, it worked before of course the control was not bound then.

    StartDate = DateAdd("yyyy", -1, Date)

    In other words, the default date is a Year past the current date.
    I can't do this? My Report does not work since it cant see an unbound field and now the form does not like it that it is , Sheeesh!

    THIS CODE WORKED; =DateAdd("yyyy",-1,Date())



    I added this to my table as well and the default value.
    Last edited by burrina; 12-27-2012 at 11:02 PM. Reason: Solved It

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

Similar Threads

  1. can't assign a new value to a form field
    By markjkubicki in forum Programming
    Replies: 4
    Last Post: 09-28-2012, 08:03 PM
  2. Replies: 2
    Last Post: 07-13-2012, 05:12 AM
  3. Replies: 3
    Last Post: 03-28-2012, 10:16 AM
  4. Formula to assign a number to a field value?
    By dashingirish in forum Queries
    Replies: 2
    Last Post: 02-23-2012, 01:21 PM
  5. Replies: 6
    Last Post: 02-09-2010, 07:53 AM

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
  •  
Other Forums: Microsoft Office Forums