Navigation Form Problem

[johnob]

Hi all,

I have made a navigation form that prints the current record out as a PDF and also the option to send the current record by email as a PDF. Both work perfect when you open the form outside the navigation form. But when you open it inside the navigation form, it does not print any of the information.

The problem is in the Query report, In the criteria box for field [RequsetID] it has

[Forms]![FRMRequestForm]![RequestID]

(The above works outside the navigation form.)
​

I have also tried adding the navigation form name

[Forms]![Main]![FRMRequestForm]![RequestID]

But none work.

Can anyone help ?

Thank you

 

[JHB]

Post a stripped version of you database with some sample data, (zip it) + name of the query/report.

 

[johnob]

Is this a switchboard created by the wizard?

No its on the create forms menu

I have attached a sample db

showing the problem

John

 

[johnob]

Maybe keep it simpler see attached.

Thanks for that,

I see that it works, but I would need to change a lot of things (see attached pic showing the headers and each one has from 3 to 20 forms attached to it.)

John

 

[JHB]

It works now, database attached:

[Forms]![Main]![NavigationSubform].[Form]![RequestID]