Navigation Form Errors

[need_help12]

Good afternoon.

Quick question re: Navigation Form. I have 5 reports (based off queries) that each utilize a combo box to make a selection and a command button to open a report based off the combo box selection. All of these were working flawlessly, and then I decided to input each form into the Navigation Form, and now I'm getting errors, specifically parameter value prompts.

Do I need to edit my queries at all now that these form are within the Navigation Form? Would appreciate any help.



Thanks!

[TG_W]

If I understand correctly, yes. You will need to filter on the parameters in your Combo Box. Example - if you are filtering on field [ID], you should add [Forms]![YourFormNameHere]![ComboBoxNameHere] in the criteria of the form.

Hope that helps.

[need_help12]

Hey TG, this didnt work, but I may not have input this correctly. I have this string [Forms]![YourFormNameHere]![ComboBoxNameHere] in criteria of my query for the field I'm filtering on. Is this where it belongs? Same parameter issue.

[TG_W]

Did you change the names or just copied and pasted the string? If you just copied and pasted, then insert your form name where it says [YourFormNameHere] and the combo box name where it says [ComboBoxNameHere]. Example - If your form name is "Form1" and combo box name is "Criteria", the string would read [Forms]![Form1]![Criteria].

[need_help12]

Oh no, I changed it. So I have a form ("frmWorkType") that I've input into the navigation form ("frmSwitchboard"). The criteria I have in the query ("qryWorkType") is [Forms]![frmWorkType]![Combo0]

[TG_W]

Ok. Hope I didn't offend you. I've seen someone do that before.

I forgot to mention adding "like" in front of the string. It should look like the snapshot.

[need_help12]

oh no offense at all, I need the help

[need_help12]

But unfortunately, that did not work either.

[TG_W]

Ok. Is it possible to post the database for further analysis? If not, maybe a few screen shots would help.

[need_help12]

Give this a try. frmSwitchboard is the Navigation form.

[TG_W]

Strange. It is giving me an unrecognized file name error when I try to open the db. Can you try uploading it again?

[need_help12]

See if this works....

[TG_W]

Still not working, but I think I have figured out what you are trying to do - show the reports in the same form as the combo box, correct?

[need_help12]

Drats. Oh well. That's not quite what I'm trying to do. All my coding worked on my switchboard I created so that that when data was selected in the combo box on any of my forms, you clicked the cmd button to run the report. All were working just fine. Once I dragged the forms into the navigation form, they ceased working.

[TG_W]

Ok. Try compact and repair then zipping again. I'm still a little hazy on what you are trying to do.