DoCmd.GoToRecord , , acNewRec

[Leslie Isaacs]

Hello All

In the OnOpen event of a particular form I have:

DoCmd.GoToRecord , , acNewRec

This works fine when the form is opened on its own, but when it is opened as
a subfom on a main form it doesn't work - the subform is always displayed
with the cursor at record number 1. How can I get the 'DoCmd.GoToRecord , ,
acNewRec' command to work on the subform?

Hope someone can help
Many thanks
Leslie Isaacs

 

[Nikos Yannacopoulos]

Leslie,

You must do it from the mai form's Open event, first setting focus to
the subform:

Private Sub Form_Open(Cancel As Integer)
Me.YorSubformObjectNameHere.SetFocus
DoCmd.GoToRecord , , acNewRec
End Sub

HTH,
Nikos

 

[Nikos Yannacopoulos]

Answered in the forms NG. Pls do not multipost!

 

[Leslie Isaacs]

Nikos
Many thanks - worked a treat.
Les

 

[Leslie Isaacs]

Sorry!
Les

 

[Nikos Yannacopoulos]

Actually you did not multi-post, you cross-posted, which is a much
lesser evil Sorry for the confusion!