Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Default Value Question

    I have a Date1 field and I want to create a Date2 field in the same table, wich will show the date from the Date1 field, but in some cases user can overwrite it. If anyone can help, I will appreciate a lot!


    Thanks

  2. #2
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14
    On your user form add [Date1] and [Date2] controls. For [Date2] default value use [formname].[Date1]. this should work. If user does not overwrite it it will hold the default value of [Date1]

  3. #3
    Join Date
    Nov 2006
    Posts
    2
    Thanks Andrew,
    BUT it doesn't work!!!
    Any other ideas? Will appreciate a lot!
    Both Date1 and Date2 from the same Table General, maybe it doesn't work because of this?
    Julia

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

Similar Threads

  1. Default Information for an existing field HELP
    By opinionsrfun in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:30 AM
  2. Default Value in table = Field plus 3 days
    By AmyLynnHill in forum Access
    Replies: 1
    Last Post: 08-03-2008, 01:58 AM
  3. Replies: 1
    Last Post: 02-10-2007, 10:21 AM
  4. Replies: 1
    Last Post: 01-08-2007, 01:21 PM
  5. Default Values
    By twainscott in forum Programming
    Replies: 0
    Last Post: 09-14-2006, 11:18 AM

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