When open a form go to the new record

[yhchen]

I made this simplest code so when the form opened it would go to the new record but sadly this simplest code in the world doesn't work...


Private Sub Action1_Open()

DoCmd.GoToRecord , , acNewRec

End Sub

On the form property, I set Open to Event Procedure but it is not working...

please help!!

 

[dapplegrey]

I've done the same thing and it works. However, I note your sub is an action1_open rather than a form_open sub. Try this below and see if that works.

Private Sub Form_Open(Cancel As Integer)

DoCmd.GoToControl "txtCallDate"
DoCmd.GoToRecord , , acNewRec
End Sub

 

[pbaldy]

That doesn't look right, as normal form open code would be:

Private Sub Form_Open()

Where it says Event Procedure, click on the ellipsis (...) to the right and put the code there.

 

[yhchen]

I've done the same thing and it works. However, I note your sub is an action1_open rather than a form_open sub. Try this below and see if that works.

Private Sub Form_Open(Cancel As Integer)

DoCmd.GoToControl "txtCallDate"
DoCmd.GoToRecord , , acNewRec
End Sub

Hi thanks a lot

The below code works...

Private Sub Form_Open(Cancel As Integer)

DoCmd.GoToRecord , , acNewRec
End Sub