starting with a new record

[Guest]

I have a form for a wildlife table that contains approx.
2000 records. When I open the form it is always on the
first record. Is there a way to start the form and have
it come up blank (so someone can begin to enter the data)
without having to click on the * at the bottom of the form?

Thanks for the help

 

[fredg]

I have a form for a wildlife table that contains approx.
2000 records. When I open the form it is always on the
first record. Is there a way to start the form and have
it come up blank (so someone can begin to enter the data)
without having to click on the * at the bottom of the form?

Thanks for the help

Code the Form's Load event:
DoCmd.RunCommand acCmdRecordsGoToNew

 

[Guest]

How do you do that? Is it an event builder?

Thanks,
Toan

 

[fredg]

How do you do that? Is it an event builder?

Thanks,
Toan

Display the form's property sheet.
Click on the Data tab.
Click on the On Load event line.
Write
[Event Procedure]
in that line.
Click on the button with the 3 dots that appears on that line.
When the Load Event code window appears, write
DoCmd.Runcommand acCmdRecordsGoToNew
between the 2 already existing lines.
Exit the code window.
Open the form.
It will open at a new record.

 

[Sean]

-----Original Message-----

How do you do that? Is it an event builder?

Thanks,
Toan
the
form?

Display the form's property sheet.
Click on the Data tab.
Click on the On Load event line.
Write
[Event Procedure]
in that line.
Click on the button with the 3 dots that appears on that line.
When the Load Event code window appears, write
DoCmd.Runcommand acCmdRecordsGoToNew
between the 2 already existing lines.
Exit the code window.
Open the form.
It will open at a new record.

--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
.
This seemed to work great. Only one thing I had to enter

the event tab not the data tab. Thanks again

Sean