open to new record

D

dlb1228

when i open my form i want it to always open to a new record i can use a
macro but is there another way to do this
 
J

John Vinson

when i open my form i want it to always open to a new record i can use a
macro but is there another way to do this
Click to expand...

One way is to set the Form's DataEntry property to True. This has the
disadvantage that it ONLY lets you see the new record (and newly
entered records) - you cannot scroll back and view previous records.

If you want both capabilities, use a Macro or VBA code in the form's
Open event to move to the new record; the VBA would be

DoCmd.GoToRecord acNewRecord

John W. Vinson[MVP]
 
B

BruceM

What is the problem with using code? A VBA procedure at the form's Open
event will get you there with very little fuss:

DoCmd.GoToRecord , , acNewRec

I don't think there's another way.
 
T

tom dautel

I also want to open my form to a new record, but the syntax in the two
previous posts is not working for me... I'm using Access 2000. Thanks for
any help!

Tom
 
Top