Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    413

    Unanswered: On New Record Add Value to Control

    Okay, I have 2 bound fields. One called GirlID and one called Last Contacted. I want the date to be entered into this field (Last Contacted) when the user enters a new record. Should the code be On Current or on exit the GirlID control or what ? The control Last Contacted is a date field with m/d/yy as it's format and 99/99/00;0;_ as a input mask.
    What do you suggest ?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    If you're saying that you want Last Contacted to be populated with the current date whenever a New Record is created, in Form Design View
    • Right-Click on the Control named Last Contacted
    • Click on Properties
    • Click on the Data Tab
    • In the Default Value Property enter =Date()

    That's all. Remove the Input Mask you have in place. They're frequently problematic, and since you're populating the Control with the Default Value Property, there is no need for it.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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