Add New Record in Datasheet subform

[mattc66 via AccessMonster.com]

Hi All,

I have an event on my main form that when you press enter it moves the cursor
to the first record on the subform. However I want it to place the cursor on
the add new record portion of the subform if there is data already found.

I hope I am saying this correct.

 

[Brendan Reynolds]

Me.sfrOrders.SetFocus
DoCmd.GoToRecord , , acNewRec

Where 'sfrOrders' is the name of the subform control.

 

[mattc66 via AccessMonster.com]

That works great - Thank you!

Me.sfrOrders.SetFocus
DoCmd.GoToRecord , , acNewRec

Where 'sfrOrders' is the name of the subform control.

Hi All,

[quoted text clipped - 5 lines]

I hope I am saying this correct.