If you only want to be able to Add New Records (but not Edit existing Records) Ajax's suggestion is fine. (DataEntry = Yes)
To Open the Form directly, in that Form's code window:
Code:
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
To Open Form from another Form:
Code:
DoCmd.OpenForm "Form1", , , , acFormAdd ''' The user can add new records but can't edit existing records.
OR
Code:
DoCmd.OpenForm "FormName", , , , acFormEdit ''' The user can add new records and edit existing records.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007