Subform does not run reports, form view works fine?

[Forbes]

Hello everyone,



I have created a form that prints reports based on date, due to the privacy of the db I cannot upload but I am willing to answer any questions you may have.

The form brings my reports just fine and i named the normal form frmreportsprint and the sub is sbformreportsprint. the code within the form does use the forms name to run for certain data.. but with the main form being the control source I don't understand why it wont execute, there error I get just says "Unknown" with no other information when I try to use the subform.

any suggestions?

[RuralGuy]

The syntax for referencing the current Form is different if you run the form as a sub form. Could that be the source of your issue?
http://access.mvps.org/access/forms/frm0031.htm

[Forbes]

So with any query or report that references back to the form name itself needs to be tweaked like Me.frmreportsprint.sbfrmreportsprint to identify the control?

AND 
timestamp Between #" & [Forms]![frmreportsprint]![txtStart] & "# And #" & [Forms]![frmreportsprint]![txtEnd] & "#")

AND 
timestamp Between #" & [Forms]![frmreportsprint]![sbfrmreportsprint]![txtStart] & "# And #" & [Forms]![frmreportsprint]![sbfrmreportsprint]![txtEnd] & "#")

like so?

[RuralGuy]

The syntax actually needs to go through the FORMS collection: Forms!MainFormName!SubFormControlName.FORM!ControlName

[Forbes]

I appreciate your help, could you elaborate "forms collection", all my code essentially is sitting on the reports and querys. on the form itself the buttons to open them is just a simple macro open. I'm far from an expert more like a blind kid in a candy store.

[RuralGuy]

Sorry! That simply means the syntax begins with FORMS! as do the examples you posted in post #3.

[Forbes]

I see what your saying so this would apply to every report/query with a reference to the main form, essentially changing all of them individually? I only ask because it's a lot of reports haha!

This is where I have the subform, the only thing the cmd.buttons do is Load the "reports" in report view, the code for the reports to gather the db info runs within the reports and queries, so can I change the cmd.button from macro to code and just link the cmd.buttons that way, it seems like it might be less tedious that changing all the reports and queries. even though it is just a copy paste job really.

AND timestamp Between #" & [Forms]![frmshippingprint]![sbfrmshippingprint.FORM]![txtStart] & "# And #" & [Forms]![frmshippingprint]![sbfrmshippingprint.FORM]![txtEnd] & "#")

[RuralGuy]

I believe the answer to your question is yes. I don't use macros so I would have to see the code to have a more definitive answer.

[Forbes]

I actually got the error to surface:


This was after just trying to redirect the queries and reports like I pasted above, so I definitely think removing the macros is going to be my best bet, let me give one of them a shot and let you know how it goes..

[RuralGuy]

Cool! I'll be around.

[Forbes]

I guess I'm not sure where to reference it here after i converted my Macros:

'------------------------------------------------------------' Command15_Click
'
'------------------------------------------------------------
Private Sub Command15_Click()
On Error GoTo Command15_Click_Err


    ' _AXL:<?xml version="1.0" encoding="UTF-16" standalone="no"?>
    ' <UserInterfaceMacro For="Command14" Event="OnClick" xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application"><Statements><Action Name="OpenReport"><Argument Name="Report
    ' _AXL:Name">Reported_Quality</Argument><Argument Name="View">Print Preview</Argument></Action></Statements></UserInterfaceMacro>
    DoCmd.OpenReport "Reported_UW", acViewPreview, "", "", acNormal




Command15_Click_Exit:
    Exit Sub


Command15_Click_Err:
    MsgBox Error$
    Resume Command15_Click_Exit


End Sub

The only other things I can think of would be the txtstart and end I mean those point right to the main form, I tried

AND timestamp Between #" & [Forms]![frmshippingprint]![sbfrmshippingprint.FORM]![txtStart] & "# And #" & [Forms]![frmshippingprint]![sbfrmshippingprint.FORM]![txtEnd] & "#")

Receiving the same error. "Unknown"

[Forbes]

Haha, I am dim sometimes, frmshippingprint was not the main form the sub form ws on just the main form of the sub form xD once i referenced as you described with the frmhome(my main form) it work just fine thank you so much!

[frmhome]![sbfrmshippingprint]

[RuralGuy]

Outstanding! Thanks for the update and marking the thread as Solved.