Open form based on 1st form selection

[jlnewbie]

I've seen several posting related to this question and on FAQ but have yet to solve my problem . I'm hoping someone will help me see solve it.
My 1st form works well and consist of combobox and subform. I select my combobox product and the subform is populated with related item. I want to open a second related details form based on selection of the subform by clicking on a subform record but keep getting that table is opened exclusively by another user and can't be control prgrammatically or the no record error. Here is the code that I have to open the second form

DoCmd.OpenForm "frmMSDSViewDetails", , , _
"lngProductID " = " & lngProductID & " '"


JLopez
lopez2059@bellsouth.net

 

[jlnewbie]

Thanks to anyone trying to answer my question but I solved my issue by adding the following code to On double click

Dim stLinkCriteria As String
stLinkCriteria = "[lngProductID]=" & Me![lngProductID]
DoCmd.OpenForm "frmMSDSDetails", , , stLinkCriteria
End Sub


JLopez
lopez2059@bellsouth.net