open to new record

[Guest]

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

 

[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

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]

 

[Guest]

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.

 

[Guest]

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