Form/Query Problem

In my subform 'Orders Special Products Details Extended subform' I have

a command button named 'cmdPrintSpecialOrderGiftReceipt' to bring up a
report preview. There is a query to fliter the report called
'qrySpecialOrdersGiftReportFilter'. When I use the button I get a ENTER

PARAMETER VALUE message box.


The code I used for the command button is:


Private Sub cmdPrintSpecialOrderGiftReceipt_Click()
On Error GoTo Err_cmdPrintSpecialOrderGiftReceipt_Click


Dim stDocName As String


stDocName = "Special Orders Gift Report"
DoCmd.OpenReport stDocName, acViewPreview,
"qrySpecialOrdersGiftReportFilter"


Exit_cmdPrintSpecialOrderGiftReceipt_Click:
Exit Sub


Err_cmdPrintSpecialOrderGiftReceipt_Click:
MsgBox Err.Description
Resume Exit_cmdPrintSpecialOrderGiftReceipt_Click


End Sub


For the query I used:
Field: qrySpecialOrdersGiftReport.*
Table:qrySpecialOrdersGiftReport
Show: Yes


Field: SpecialOrderID
Table: qrySpecialOrdersGiftReport
Show: No
Criteria: [Forms]![Orders Special Products Details Extended
subform]![SpecialOrderID]


Can anyone offer assistance in detecting where my error is? Thank you
for the support


If I can ever get it working right I will change to acViewNormal
instead of preview.

The problem is you need to identify the main form in your criteria.
Criteria: [Forms]![MyMainFormNameGoesHere]![Orders Special Products Details
Extended subform]![SpecialOrderID]


"Lisa" wrote:

In my subform 'Orders Special Products Details Extended subform' I have

a command button named 'cmdPrintSpecialOrderGiftReceipt' to bring up a
report preview. There is a query to fliter the report called
'qrySpecialOrdersGiftReportFilter'. When I use the button I get a ENTER

PARAMETER VALUE message box.


The code I used for the command button is:


Private Sub cmdPrintSpecialOrderGiftReceipt_Click()
On Error GoTo Err_cmdPrintSpecialOrderGiftReceipt_Click


Dim stDocName As String


stDocName = "Special Orders Gift Report"
DoCmd.OpenReport stDocName, acViewPreview,
"qrySpecialOrdersGiftReportFilter"


Exit_cmdPrintSpecialOrderGiftReceipt_Click:
Exit Sub


Err_cmdPrintSpecialOrderGiftReceipt_Click:
MsgBox Err.Description
Resume Exit_cmdPrintSpecialOrderGiftReceipt_Click


End Sub


For the query I used:
Field: qrySpecialOrdersGiftReport.*
Table:qrySpecialOrdersGiftReport
Show: Yes


Field: SpecialOrderID
Table: qrySpecialOrdersGiftReport
Show: No
Criteria: [Forms]![Orders Special Products Details Extended
subform]![SpecialOrderID]


Can anyone offer assistance in detecting where my error is? Thank you
for the support


If I can ever get it working right I will change to acViewNormal
instead of preview.

Thank you! It works with no problem now. I really appreciate the
assistance.