Navigation Form Errors

[need_help12]

i think this is my last hurrah. If I cant solve this soon, I'm going to abort and just build my own navigation form.

[TG_W]

Yeah, it's still not working for some reason.

One more blind stab at it - Have you checked all the coding from the cmd button to make sure it is reading from Navigation Form?

[need_help12]

Yes, sir. And that's where the root cause is. If I run the forms alone (and not off the Navigation Form) then all 5 of them run beautifully. Once I try to run them through the navigation form, all 5 generate parameter issues.

[TG_W]

Well, I have been able to recreate the error in another testing database I have. I am able to get certain functions to work, but I cannot get it to filter without a parameter setting window coming up.

Do you just want to be able to select a report and then set the parameters from one window?

[need_help12]

Yes. I created a form for each report that has a combo box it in so end-users can select their parameter that way. When I drop the forms into the navigation window, I get those errors, but if I manually enter the parameter into the pop up parameter value box, the report runs just fine. I just dont want those parameter boxes to appear period, that's why I made the combobox forms.

[need_help12]

Got it! Once you drop the form into the navigation form, it becomes a subform and you have to change the criteria on the query. Here's what I made the change to:

[Forms]![MainFormName]![NavigationSubform].[Form]![ControlName]

[TG_W]

What's frustrating is I found that code but it wouldn't test right for me to suggest it. Glad you were able to get it working!

[TG_W]

And now I got it working...