M
mhmaid
i have five reports . want to make one form with multi-select list to select
one or more from the reports list .and i have one button which i want it to
do that thru code.
can any body help me with this code. i am getting this message now
"object doesnt support this property or method"
this is the code i have in the on click of the button
Private Sub Command4_Click()
On Error GoTo Err_Command4_Click
Dim stDocName As String
strDocName = Forms![View Reports].Form.[Command4]
strLinkCriteria = "[IDNO]=[Forms]![NEW CASES]![IDNO]"
DoCmd.OpenReport strDocName, , , strLinkCriteria
Exit_Command4_Click:
Exit Sub
Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click
End Sub
one or more from the reports list .and i have one button which i want it to
do that thru code.
can any body help me with this code. i am getting this message now
"object doesnt support this property or method"
this is the code i have in the on click of the button
Private Sub Command4_Click()
On Error GoTo Err_Command4_Click
Dim stDocName As String
strDocName = Forms![View Reports].Form.[Command4]
strLinkCriteria = "[IDNO]=[Forms]![NEW CASES]![IDNO]"
DoCmd.OpenReport strDocName, , , strLinkCriteria
Exit_Command4_Click:
Exit Sub
Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click
End Sub