Results 1 to 4 of 4
  1. #1
    rlbroerman
    Guest

    opening form (2003)

    1. How do you open a form with a blank record. I still want to use AUTOEXPAND
    2. How do you open a form and have cursor be on a specific field?
    Thanks

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

    Re: opening form (2003)

    1. Do you want existing records to be available, or only a blank record? What do you mean by "I still want to use AUTOEXPAND"?

    2. If you always want a specific control to have the focus, set the Tab Index property of this control to 1, or drag the control to the top in Edit | Tab Order.

  3. #3
    rlbroerman
    Guest

    Re: opening form (2003)

    Yes' I do want existing records to be available but I want to start with a blank record. When I start typing I want the AUTOEXPAND function to work

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

    Re: opening form (2003)

    You can create an On Load event procedure for the form:

    Private Sub Form_Load()
    On Error Resume Next
    ' Go to a new record
    RunCmmand acCmdRecordsGoToNew
    End Sub

    If the first control in the tab order is a combo box, autoexpand should work. I don't have Access 2003, so I don't know if autoexpand has more capabilities there.

Posting Permissions

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