Code no longer works for new record

[Prufrock]

I have used the following
Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub
for quite a while to get a form to open to a new record or they can navigate back through records. I am using Access 2007 and find it no longer works. Have tried it in On Open, On Load, OnFocus etc. Just opens to the first record.

All Allows such as Additions etc are YES, Data Entry and record Locks are No. Can anyone assist?

 

[missinglinq]

In ACC2007, code has to be "enabled" if you will, by certifying it as "safe." There's an explanation here:

http://www.accessmonster.com/Uwe/Fo...692/VBA-code-not-picking-up-Acess-2007-events

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya Prufrock . . .

Have you tried the [blue]Load[/blue] event instead?

See Ya! . . . . . .

Be sure to see thread181-473997

 

[Prufrock]

Thanks for your help.