starting with a new record

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

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
 
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
Click to expand...
Code the Form's Load event:
DoCmd.RunCommand acCmdRecordsGoToNew
 
How do you do that? Is it an event builder?

Thanks,
Toan
Click to expand...

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.
 
-----Original Message-----
How do you do that? Is it an event builder?

Thanks,
Toan
the
form?
Click to expand...

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
Click to expand...
the event tab not the data tab. Thanks again

Sean
 
Back
Top