Open a form at a new record

G

gavin

I seem to recall this was asked fairly recently but I can't find the post.
How do I open a form with a new (blank) record. I know if I set the form's
Data Entry property to Yes I get a new record but in this case I can't see
the other records already entered into my table. Can anyone tell me how to
do this?


Regards,


Gavin
 
P

PC Datasheet

Put the following code in the Open event of the form:
DoCmd.GoToRecord,,acNewRec
 
P

PC Datasheet

Look at the GoToRecord Method n the Help file. The commas are placeholders
for optional parameters.

Steve
PC Datasheet
 
P

PC Datasheet

If you ever need outside help on any projects, be sure to keep me in mind.

Steve
 
Top