set form for new record

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

Guest

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
Click to expand...

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