Navigating Form from Subform

[Guest]

The main form has no data, but is used to select data from a combo box and
update the current record in the sub form. It has the combo box and an
UPDATE button that updates field in the current record of the sub form.

I have been upable to determine how to move the current record in the
subform from the main form. My first attempt was:

DoCmd.GotoRecord acDataForm, Forms!Mainform.form!SubForm.Name, acNext

The error says the form is not open.

I want to move to the next record in the subform when the user updates the
current record to speed up datat entry.

Thanks.

 

[Guest]

Hi Klatuu, have you tried

Me.SubFormName.SetFocus
DoCmd.GoToRecord , , acNext

 

[Guest]

I thought I had, because it does work. I just added a setfocus back to my
combo so I can correct the next record.

Thanks.