I have a Form of a “query” type, and that query asks for a :variable. I want to write a macro that passes something as that variable when refreshing that form. Is that possible?
While we’re at it, is it possible to write a macro to execute another query from the same project and pass a variable to it?
I am trying to read the manual, which has something about establishing connections with databases and running queries, but that doesn’t look like what I want. I just want to call a query that’s already in the project I’m working with, one that might even be associated with the form this macro is being run from! Is there no simple way to, like, result=ThisProject.PredefinedQueries.getByName(“MyQuery”).Execute?!..