when form opens go to a new record

G

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.
 
R

Rick Brandt

Gary said:
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.
Click to expand...

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

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
 
Top