Form Functions properly on its own, but not when used as a subform

[halabis]

I am having an issue where a form I have created to run a report based on criteria from a dropdown is functioning perfectly. However, when I place the form within another as a subform, the run report button is no longer drawing the query criteria from the dropdown menu, but rather pops up a dialogue box. Why would the form work perfectly by itself, but not as a subform?

Thanks!

[halabis]

Update with more information. I have changed nothing, but for a brief moment in time, It pulled one query properly, then each time I tried to pull another query, the pop up dialogue didnt appear, but it pulled the data from what I selected in the dropdown previously, and not my current selection.

After closing access and reopening, i can no longer replicate that feat. I am now back to getting the pop up 100% of the time.

My query criteria is "[Forms]![AgentReportDropdown]![PullAgentReport]", I have verified that the forms and combo box are all named properly.

[NTC]

When you place the form into another form, as a subform - then the criteria syntax must change:

[Forms]![MainFormName].[SubFormName].Form![SubFormControlName]

[halabis]

I changed the query criteria to the following and am still encountering the exact same issue.

[Forms]![AgentReportDropdown].[NavigationSubform].[form]![PullAgentReport]

[NTC]

for a query to call criteria from a field located in a sub form - it must have the syntax as I posted before. that much is certain

so either there is a misinterpretation of what you seek to do, or you have a typo or some error in regard to your implementation.....

[halabis]

Here is a screen shot of what is occurring. is it because the dropdown is showing as unbound? If so, what to I set as its control source? The control source drop down doesnt have any options for me to select.

[NTC]

well the main form is named Attendance Forms I see in its tab...... and if your sub form is continuous then you can't call a control - though I can't tell if that is the case. I would also copy your objects into a regular form rather than a navigation form.

[halabis]

Unfortunately I don't know enough about access to even understand what you just said. =) Back to trial and error I suppose.

[halabis]

Problem solved.

I changed the query filter to

[Forms]![Attendance Forms].[NavigationSubform].[form]![PullAgentReport]

and everything worked fine.

Thanks!

[HiTechCoach]

TIP: Use TempVars to pass data from a form to a query. This solves many headaches with rm references and the Navigation form.

See: https://blogs.office.com/2010/09/27/...2007-and-2010/