Search results

  1. R

    Parameter prompt twice, only when using a form

    I get it- I am focused on the form- sorry- I feel like I've said that a few times. Thank you. There is no code associated with the form. There is no filter on the form. There is nothing basically on the form, except the call to the query as the data source and some basic button commands (exit...
  2. R

    Parameter prompt twice, only when using a form

    Yup- thanks. I am aware of that. The parameter prompts are in the queries this query calls. But there is no issue with those queries either. They all run happily and as they should. I am wondering if anyone has encountered this problem or a problem like this when they call a parameterized query...
  3. R

    Parameter prompt twice, only when using a form

    Yup- when I open from the Navigation Pane or use the command button, the parameter dialogue runs twice. When I open the query directly from the Nav Pane, it only opens once. I went through each of the queries the crosstabs query references last night to see if one of them was double...
  4. R

    Parameter prompt twice, only when using a form

    Sure thing. Like I said, there's no problem with the query itself, runs as it should. There's something happening when I put the form on top- when I open it directly as a form and when I use this command button to open it, the parameters input runs twice. I was trying to avoid sharing the query...
  5. R

    Parameter prompt twice, only when using a form

    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...
  6. R

    Hi!

    Hi! I've been stumbling my way into learning VBA over the last couple of years and have built a decent db for my organization. I'm in the northeastern US, currently hanging out with my cat and zooming with others. Happy to be here!
Back
Top Bottom