Solved Code for a button in the main form

[Alex Motilal]

Hello experts,
I do have a Main form with a continuous SubForm. When the button on the main form is clicked, another form should open based on the record selected in the SubForm.
I need the code for that.
Thanks
Alex

 

[arnelgp]

on the Click Event of your button add code:

Private Sub button1_Click()
DoCmd.OpenForm FormName:="theNameOfFormToOpen",WhereCondition:="[PKFieldName] = " & Me![SubformName].Form![PKTextboxName]
End Sub

 

[Alex Motilal]

on the Click Event of your button add code:

Private Sub button1_Click()
DoCmd.OpenForm FormName:="theNameOfFormToOpen",WhereCondition:="[PKFieldName] = " & Me![SubformName].Form![PKTextboxName]
End Sub

Thank you. However, it is showing Run time error 2465.

 

[Alex Motilal]

Thank you. However, it is showing Run time error 2465.

Sorry, I put the name of the subform, instead of the name which I gave in the main form.
It is working fine.
Thanks a lot.