when form opens go to a new record

[Gary]

Hi i'm using a form purely for adding records.
So when it's open i want it to insert a new record, i'm assuming the
best way for me to do this would be an 'on open' event.

does anyone know what vba code works in a simmilar way to the insert
record button on the record navigation bar?

thanks,

Gary.

 

[Rick Brandt]

Hi i'm using a form purely for adding records.
So when it's open i want it to insert a new record, i'm assuming the
best way for me to do this would be an 'on open' event.

does anyone know what vba code works in a simmilar way to the insert
record button on the record navigation bar?

thanks,

Gary.

Set the DataEntry property to Yes. That is exactly what it is for.

 

[Larry Daugherty]

There are many ways to get done what you want: properties, event code,
command buttons. The simplest is to open the form in design mode and
set the Data Entry property to Yes. That will cause any data entered
to be added to the underlying table when you navigate off the current
record.

HTH