Open Tab in Form to Specific Record

[adrienne_r30]

Currently, I have a form with tabbed pages in it. The second tab, I have a subform inserted into it. I have a completely separate form that looks through records. I want to be able to click on a record from the separate form and open the Main tabbed form, to the second tabbed page, to a specific record. Currently I have:

Private Sub Form_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_Main_Data_Entry"

DoCmd.OpenForm stDocName, , , stLinkCriteria

Forms![frm_Main_Data_Entry]![pgAgreement].SetFocus

End Sub


which opens up to the tabbed page just fine. but I can not figure out how to get to a specific record.

Also, the subform in the tabbed page, doesn't have the same controls as the Main tabbed Form itself, so when I add something like:


strCriteria = "Agreement_Number = " & Me.Agreement_Number

it won't work because it is not reading from the subform in the tab, rather its reading from the main form controls.

 

[pbaldy]

The wherecondition won't work on a subform. One option would be to modify the form references here to refer to a subform:

http://www.baldyweb.com/Bookmark.htm