open to new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]
 
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.
 
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
 
Back
Top