Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Mt. Olive, North Carolina, USA
    Posts
    170
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Default Value Property (2000)

    I have a data entry form to enter records. The data date could be any date so I cannot use =Date() in the default value property box. Right now the operator opens the form in design view and enters a date in the default value box then open the form and enters the data. There must be a better way. I was thinking about opening a new form that would have a text box on it so I could enter a date then refer to that text box on the data entry form in the default value of the date field. I tried "#" & "[Forms]![xfrmdate]![Card_Date]" & "#" but I got an #error pop up in the field. xfrmdate is the new form and card_date is the text box on that form.
    Is it possible to do what I want to do or is there a better way to accomplish this task?
    Thank you in advance.
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Value Property (2000)

    You don't need the # characters around the date here, nor the quotes. Just set the Default Value property to

    [Forms]![xfrmdate]![Card_Date]

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Mt. Olive, North Carolina, USA
    Posts
    170
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Default Value Property (2000)

    I had trouble at first getting it to work since I only had the 1 text box on the form. I finally realized that I still had to hit enter after I had enter the date. Now the form also has command buttons that I tab to and open up various forms that use the date entered on the first form. Thanks for setting me straight.
    All the Best to you.

Posting Permissions

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