open form in add new record status by default

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Andrew said:
I have a table with some values allready. When i'm opening the form "ADD",
Click to expand...
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
Click to expand...

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
 
Back
Top