D
Diane
How do I make the form go to a new record as I open it so
it is ready to fill in.
it is ready to fill in.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Farnham
Hi Diane
On the On Open event of the form insert the following:
DoCmd.GoToRecord , , acNewRec
Assuming you're using Access 2000
HTH
Debra
On the On Open event of the form insert the following:
DoCmd.GoToRecord , , acNewRec
Assuming you're using Access 2000
HTH
Debra
J
John Vinson
How do I make the form go to a new record as I open it so
it is ready to fill in.
Two possibilities:
- If you JUST want to enter data, and don't want to even see old
records, set the DataEntry property of the Form to True.
- If you want to default to entering new records, but still want the
ability to scroll back and see old ones, put the following VBA code in
the Form's Open event (by viewing the form's properties, finding the
Open event on the Events tab, clicking the ... icon and choosing Code
Builder):
Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acNewRecord
End Sub