J
jskernahan
Hi,
I have a subform (which opens in datasheet view) embedded in a main
form. On the main form I have a button that opens a pop-up form. I
want to be able to select a value in the subform, click the button on
the main form, and output the value selected on the subform into the
main form. I have the following code written:
Private Sub Command1_Click()
Dim where As String
where = "[UWI] = " & Query!sfrmAvailToLic_Estimated_Date!UWI
DoCmd.OpenForm "popupfrm_PM_Comments", , , where
End Sub
when I run the code, I get the following compiler error:
Qualifier must be collection
I believe the error is in the line Query!sfrmAvailToLic_Estimated_Date!
UWI but I cannot figure out how to fix it, please help!!! thanks
I have a subform (which opens in datasheet view) embedded in a main
form. On the main form I have a button that opens a pop-up form. I
want to be able to select a value in the subform, click the button on
the main form, and output the value selected on the subform into the
main form. I have the following code written:
Private Sub Command1_Click()
Dim where As String
where = "[UWI] = " & Query!sfrmAvailToLic_Estimated_Date!UWI
DoCmd.OpenForm "popupfrm_PM_Comments", , , where
End Sub
when I run the code, I get the following compiler error:
Qualifier must be collection
I believe the error is in the line Query!sfrmAvailToLic_Estimated_Date!
UWI but I cannot figure out how to fix it, please help!!! thanks