Set the form's "data entry" property to true.

Signature
Hope that helps!
RBear3
.
> I have a form when ever it is reopened form showing the first record
> but insted i want the form to set for new record as it opened
> how to do this please
> balu
> I have a form when ever it is reopened form showing the first record
> but insted i want the form to set for new record as it opened
> how to do this please
> balu
You can set the Form's Data Entry property to Yes, as Rbear3 suggests; this
will work but has the disadvantage that you cannot then use the form to see or
edit existing records.
An alternative is to open the Form in design view. View the Form's Properties;
on the Events tab find the Load property. Click the ... icon by it and choose
"Code Builder". Access will give you a Sub and End Sub line, just add one
more:
Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord
End Sub
John W. Vinson [MVP]