Subform to move record on "parent" form
this was the motivation to finally register...
I am trying to use docmd.gotorecord. The trouble is I am trying to use it on a subform to move to the record on the parent form.
Some of the things I have tried...
parent - Form_OrderDataEntrySubForm or
[Forms]![Master]![OrderDataEntrySubform]
subform combobox - subSelectOrderId
on the sub-form - afterUpdate()
' DoCmd.GoToRecord acForm, Form_OrderDataEntrySubform, acGoTo, CInt(subSelectOrderID.ListIndex + 1)
' DoCmd.GoToRecord , Me.Parent, acGoTo, subSelectOrderID.ListIndex + 1
Dim recordIndex As Long
recordIndex = subSelectOrderID.ListIndex + 1
DoCmd.GoToRecord , [Forms]![Master]![OrderDataEntrySubform], acGoTo, recordIndex
' Me.Parent.ListIndex = subSelectOrderID.ListIndex + 1
Many thanks for any help...
J.
Re: Subform to move record on "parent" form
Welcome to Forums, jjoyce! :wave:
Since it's a VBA code I think you have a better chance to get answered in the Office Development forum.
Re: Subform to move record on "parent" form
Re: Subform to move record on "parent" form
Moved to Office Development
Re: Subform to move record on "parent" form