Results 1 to 4 of 4
  1. #1
    braveali is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    31

    Question How to jump on a new record when forms open?


    Hello

    i am very new in Access (2010), i have created a small stock entry database, i want when ever i open my form, it always open with add new entry, currently it opens with the 1st record i created.

    for example, i have entered 10 new entries, and when ever i closed the form and reopen it, it always start with the 1st record..

    i have created a form button to jump on the new record, but i want as soon as i open my stock entry form, it come with fresh (new) entry instead show me the 1st record.

    here is the .jpg file attached (thats what i see when open the form)

    i will appreciate your help in this!

    thanks
    Attached Thumbnails Attached Thumbnails NewRecord.jpg  

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You will want to open the form in design view then go to the form's property sheet. Under the data tab change the Data Entry property from No to Yes.

  3. #3
    braveali is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    31
    Thanks for your reply, i did it with some other procedure, in the form properties, OnLoad>> Code Builder >> i typed the this code >> DoCmd.GoToRecord , , acNewRec and it works fine for me, but next time i will try the one you have advised me.

    Thanks

  4. #4
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Glad to hear that you found a solution

Please reply to this thread with any new information or opinions.

Similar Threads

  1. HOW TO: Button to open different forms?
    By Natan in forum Programming
    Replies: 5
    Last Post: 08-01-2011, 01:58 PM
  2. Use MsgBox to open different forms
    By blueraincoat in forum Forms
    Replies: 10
    Last Post: 03-13-2011, 10:40 PM
  3. If record does not exist, open add new record form
    By RobertIngles in forum Programming
    Replies: 2
    Last Post: 02-01-2011, 08:47 AM
  4. too many forms open
    By Jaad in forum Database Design
    Replies: 0
    Last Post: 02-22-2010, 08:39 AM
  5. Avoid jump to first data after insert new picture
    By gigolomoden in forum Programming
    Replies: 0
    Last Post: 08-04-2008, 10:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums