|
-
Apr 19th, 2006, 09:24 AM
#1
Thread Starter
New Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|