R
Robert_DubYa
I would like to get the value of a cell on a subform when it is clicked on
and place that value into a variable. I have tried to simply go to the
subform, declare the variable in VBA and set the oject of the sub query equal
to the variable. Here is my code in the subquery:
Private Sub Parent_DblClick(Cancel As Integer)
strPegPart = Me.Parent
MsgBox strPegPart
End Sub
This method would works with a regular form but not a subform. I declare
the value of srtPegPart at the form level.
My overall goal is to have the user double click on a part number in the
subform and that populates a text box on the main form that will re-query the
subform. If I can get the msgbox to work correctly I know I can get the
process to work.
thanks!
Robert
and place that value into a variable. I have tried to simply go to the
subform, declare the variable in VBA and set the oject of the sub query equal
to the variable. Here is my code in the subquery:
Private Sub Parent_DblClick(Cancel As Integer)
strPegPart = Me.Parent
MsgBox strPegPart
End Sub
This method would works with a regular form but not a subform. I declare
the value of srtPegPart at the form level.
My overall goal is to have the user double click on a part number in the
subform and that populates a text box on the main form that will re-query the
subform. If I can get the msgbox to work correctly I know I can get the
process to work.
thanks!
Robert