J
JohnE
Hello. I have a main form that has a tabcontrol on it. One of the tabs has
a subform on it that will list the many of the mainform's one. This is a
parent/child hierarchy set up. So the parents and children are all in one
table. A parent can also be a child and a child can also be a parent.
Anyway, below is the code that I originally used for making the change. Now
it does not and I do not see why. The button that I am using is inside the
subform that when used takes and changes the mainform to the selected record
and the subform as well. The txtChangeRequestID is the PK field in the
subform that is the PK field on the main form.
Dim frm As Form
Set frm = Me.Parent
frm.SetFocus
With frm.RecordsetClone
.FindFirst "ChangeRequestID=" & Me!txtChangeRequestID
If Not .NoMatch Then frm.Bookmark = .Bookmark
End With
Me.Parent.TabCtl195.Pages("pagGeneralInformation").SetFocus
Can someone please take a look at this? Also, if someone has a better idea,
I am open for suggestions.
Thanks...John
a subform on it that will list the many of the mainform's one. This is a
parent/child hierarchy set up. So the parents and children are all in one
table. A parent can also be a child and a child can also be a parent.
Anyway, below is the code that I originally used for making the change. Now
it does not and I do not see why. The button that I am using is inside the
subform that when used takes and changes the mainform to the selected record
and the subform as well. The txtChangeRequestID is the PK field in the
subform that is the PK field on the main form.
Dim frm As Form
Set frm = Me.Parent
frm.SetFocus
With frm.RecordsetClone
.FindFirst "ChangeRequestID=" & Me!txtChangeRequestID
If Not .NoMatch Then frm.Bookmark = .Bookmark
End With
Me.Parent.TabCtl195.Pages("pagGeneralInformation").SetFocus
Can someone please take a look at this? Also, if someone has a better idea,
I am open for suggestions.
Thanks...John