Seeking a User Friendly enter Button Logic

[justphilip2003]

I am trying to write a simple data entry db for my wife (not computer literate) to organize her collection of children books. I would like to place a button on the data entry form that says "ENTER" rather than to repeatedly remind her to click the new record arrow at the bottom of the Form. TIA Phil

[pbaldy]

Look at GoToRecord in VBA help.

[justphilip2003]

Thanks forthe search words! I found boblarson’scode “DoCmd.RunCommand acCmdRecordsGoToNew” and it works beautifully. Inresearching I found a report by nschroeder at
http://www.access-programmers.co.uk/forums/showthread.php?t=200184 infering that the code “DoCmd.GoToRecord,,acNewRec” does not work in Access2010. Can you tell me if this is still true? Thanks angain for the wonderfulaid you all give! Phil

[pbaldy]

Happy to help!

DoCmd.GoToRecord , , acNewRec

works fine in my copy of 2010.

[justphilip2003]

Thanks again, I placed this code in my EP as a remark for future consideration in my learning process. Phil