Results 1 to 2 of 2

Thread: Forms

  1. #1
    Join Date
    Dec 2010

    Red face Unanswered: Forms

    I need to create a form that will hold fixed date field and allow multiple records. Each record will represent a head count and volume for a pick module, but the date needs to be the same for each record. I don't want the user to have to put the same date in repeatedly.....Any ideas what that kind of form is called?

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    There is no native 'kind of form' that does this, you have to program your form to do it.

    In your form, you can use the AfterUpdate event of the date control to set the DefaultValue for the field. From that time forward, until you either manually change the data or close your form, the date will be entered automatically in each new record.
    Private Sub DateControlName_AfterUpdate()
     Me.DateControlName.DefaultValue = """" & Me.DateControlName.Value & """"
    End Sub
    Linq ;0)>
    Hope this helps!

    The problem with making anything 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