How to address subform in DoCmd?

[flofi]

Hi

How can I address a subform with DoCmd. E. g. to save the current record or goto another record in the subform. I can't use Me... because the command button is located in the mainform.

When I was using
Call DoCmd.GoToRecord(acDataForm, subformName, acGoTo, recordIndex)
the subform was not found because it is not open.

Thanks

 

[Mile-O]

Syntax for subforms

 

[Rich]

use two set focus statements

.yourSubFormName.SetFocus
SomeControlOnSubForm.SetFocus
DoCmd. GoToRecord acNewRec

 

[flofi]

That's good stuff!

Thanks to you both