I, too, would have guessed that Form_Open was too early for this to work, but testing, using the Form_Open event to call the OnClick event of Command Button whose code is
DoCmd.GoToRecord , , acNewRec
works quite well. Are you absolutely positive the button was named ADD? Is this code in the Code Module behind the Form the button resides on? I assume that the button, when clicked, works; is this true?
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007