Setting GoToNewRecord on a subform

L

Leslie Isaacs

Hello All

I have a form with a subform.
The OnOpen event of the subform is:

Private Sub Form_Open(Cancel As Integer)
Me.OrderBy = "[presc_ID]"
Me.OrderByOn = True
DoCmd.GoToRecord , , acNewRec
End Sub

This all works OK when the subform is opened on its own (from the main db
window), but when it is opened as part of the main form only the OrdrBy part
seems to work - the DoCmd.GoToRecord , , acNewRec bit doesn't work, and the
cursor is always initially on the first line. Why is this, and what can I do
to get the subform to open on a new line?

Hope someone can help.

Many thanks

Leslie Isaacs
 
Top