open form in add new record status by default

[Andrew]

I have a table with some values allready. When i'm opening the form "ADD", I want automatcally to be opened in add new record status, not to have to scroll to the end or to press a add button.

Can anyone help me in this problem
thanks

 

[Arvin Meyer]

I have a table with some values allready. When i'm opening the form "ADD",

I want automatcally to be opened in add new record status, not to have to
scroll to the end or to press a add button.

Can anyone help me in this problem?
thanks

In the OnOpen event of your form, select [Event Procedure] then clicl on the
ellipes button. Add the following line of code code:

DoCmd.GoToRecord , , acNewRec
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access