make the record in a subform move to a new record

[phleduc]

The subform is not linked to the main form, I navigate by using a recordset
clone and syncing with another form that contains a list of the contacts

I tried this but it tells me that the frmClientsContactsDetail is not open,
perhaps it is just a question of a different syntax?
(such as forms!frmClients!frmClientsContactsDetail) though that does not
work?
DoCmd.GoToRecord acDataForm, "frmClientsContactsDetail", acNewRec

It should be simple to have this form move to a new record?

Thanks for your help

Philip

 

[storrboy]

The subform is not linked to the main form, I navigate by using a recordset
clone and syncing with another form that contains a list of the contacts

I tried this but it tells me that the frmClientsContactsDetail is not open,
perhaps it is just a question of a different syntax?
(such as forms!frmClients!frmClientsContactsDetail) though that does not
work?
DoCmd.GoToRecord acDataForm, "frmClientsContactsDetail", acNewRec

It should be simple to have this form move to a new record?

Thanks for your help

Philip

I think I've missed the first part of the thread so forgive me if this
has been mentioned already.
When you refer to a subform you have to access the actual form within
that subform control.
The syntax will vary depending on where you are calling this from

Forms!MainFormName!SubFormControl.Form.Name

Will return the name of the form inside the subform control.