Subform focus on new record

[Costefran]

Hello

I have a subform on a main form set to continuous forms and would like to move focus to the next 'new record' on the continuous form after the existing record is completed (perhaps on an after event action)

If this makes sense could anyone advise if this is possible

Thanks

 

[Remou]

DoCmd.GoToRecord has NewRecord as one option, however, you may wish to consider using the Data Entry property of the form, instead.

 

[Costefran]

Thanks

I have run the goto new record in a macro and the macro fails. When I click the halt button on the macro failed message box I eventually get the message that the subform is not open although I am actually in the subform

Any further help would be appreciated

 

[Remou]

I do not use macros, but I guess the first thing to do is to set focus to the subform control. Do not use a name for the object.