rachelmillerm
New member
- Local time
- Yesterday, 20:58
- Joined
- Jan 6, 2022
- Messages
- 6
Hi! So. Without talking about the pros/cons of using parameter values prompts, I have a thing I can't quite resolve. I have a large crosstabs query that calls on multiple other queries. When I just open it as a query, it asks for the reporting period (the parameter input) no problem.
I made a pretty form for the output, and now when I access the query via a command button, it asks for the parameter values twice. There is nothing in the structure of the query (1 parameter only etc.) that would make it do this and again, it only happens when I call it via the form.
Any ideas of places to look?
Thank you.
I made a pretty form for the output, and now when I access the query via a command button, it asks for the parameter values twice. There is nothing in the structure of the query (1 parameter only etc.) that would make it do this and again, it only happens when I call it via the form.
Any ideas of places to look?
Thank you.