Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Open form to new record (Windows 2000)

    Stupid question: How do you open a form to a new record when you click on the form or a shortcut to the form. Mine keeps opening to the first record of the database.

  2. #2
    New Lounger
    Join Date
    Feb 2003
    Location
    Northfield, Minnesota, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open form to new record (Windows 2000)

    You can make a macro to open the form.
    Choose OpenForm
    Set the Data mode to Add

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

    Re: Open form to new record (Windows 2000)

    If you want to use the form ONLY to enter new records, set its Data Entry property to True in design mode.

    If you want all existing records to be visible, but to start on a new record, write code in the On Load event of the form.
    - Open the form in design view.
    - Activate the Event tab of the Properties window.
    - In the On Load event, select Event Procedure from the dropdown list.
    - Click the ... to the right of the dropdown arrow.
    - Make the code look like this:

    Private Sub Form_Load()
    RunCommand acCmdRecordsGoToNew
    End Sub

    - Switch back to Access, close and save the form.

Posting Permissions

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