Results 1 to 7 of 7

Thread: New Record

  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: New Record

    Hi,

    I’ve built a table and form (access 97) to record customer details, all if fine except that when I open the form it goes to the 1st record, is there anyway I can amend this so that when opened it goes to a new record rather than the 1st?

    Thanks for your help
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2004
    Posts
    214

    i made a macro

    that is set to run when the form opens.
    The macro just has one parameter, and that is to go to "new record".

    Also you can go to form properties and set dataentry to yes, but this will only show one new record while the rest are unaccessable. This maybe what you are actually looking for, if not, use the macro above.


    Good Luck!

  3. #3
    Join Date
    Mar 2004
    Posts
    36
    Hi

    Thanks for the reply, sorry I'm only a novice! I take it have have to put some code in, where do I do this?

    Thanks

  4. #4
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    you can add this line to open event of your form and it will go to a new record when you open your form.
    Code:
    RunCommand acCmdRecordsGoToNew
    ghozy.

  5. #5
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313

    here you go

    Just added:

    DoCmd.GoToRecord , , acNewRec

    to the OnOpen Event for the form.

    HTH
    Attached Files Attached Files

  6. #6
    Join Date
    Feb 2004
    Posts
    214

    ...

    if you don't know vb, you can create a macro.
    Open a new macro
    Under Action, put it GoToRecord
    Below there will be some options such as
    object type: form
    Object Name: your form
    Record: New

    And that is it.
    Then go into form properties and under Event
    choose your query for "On Load" or "On Open"

  7. #7
    Join Date
    Mar 2004
    Posts
    36
    Brilliant it works!! Thanks for your help guys

Posting Permissions

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