Subform to open a filtered form

[DeoM]

Hi,
I have a WORKORDERform with a PARTsubform. I want to click on a record in the PARTsubform which will open the PARTINFOform but will show only the particular record based on the PartID of the PARTsubform. Here's my code:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "PARTINFOForm"
strPartID = Forms![WORKORDERform]![PARTsubform]!PartID
stLinkCriteria = "[PartID] = " & strPartID
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[DoubleD]

Check out this site for how to correctly reference a subform.

http://www.mvps.org/access/forms/frm0031.htm

I am what I am based on the decisions I have made.

DoubleD

 

[Zion7]

Comme ça...

stDocName = "PARTINFOForm"
strPartID = Forms![WORKORDERform]![PARTsubform].Form!PartID
stLinkCriteria = "[PartID] = " & strPartID

n'est-ce pas?