Open a form with a blank record

[arlequin]

Hello!

I want to open a form in order to insert a new record by default, but Access loads the last record instead.

How can I start a form with no data on it?
I mean... all fields blank... Arlequín
arlequin@montevideo.com.uy

http://www.arlequinadas.com

 

[bobbster2000]

How is this form being opened? Switchboard? Command button?

 

[arlequin]

bobbster2000,

Thanks for answering. The form is opened by a command button placed in another form caller Main Menu.... Arlequín
arlequin@montevideo.com.uy

http://www.arlequinadas.com

 

[Databaseguy]

Set the order entry property of the form to true. It will automatically go to the last record in the uunderlying recordset. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[number2]

In the event the form is called by an event procedure, what code would open the form with a new record?
Thanks!

 

[James79]

In the "On Load" Event of the form you would place this line.

DoCmd.GoToRecord , , acNewRec

For common functions like this, use the wizards for the command buttons like new record, delete record, go to record etc, and then cut and paste the code to the event that you want. That is how I got that piece of code. It is a really quick way to get some of the generic code that will work everywhere.

 

[leobaby]

You could also set the data entry property of the form to true. But this hides all of the previous records.
LB