Controlling position of query window

[Tim]

Good afternoon,

I have a crosstab query that I use to essentially show coordinate
values on an X x Y grid. The user can click a button to see the
coordinates and up pops my crosstab query in the typical query way (a
datasheet). I would have used a form to complete this task, but it
appears that you cannot use a crosstab query in a form (at least not
in Access XP). I want to use VBA to move the position of the query
window on the screen, but I am clueless how to lock onto this window.
If, for example I had a form that was being used for the same thing, I
would simply use

dim frm as access.Form
set frm = forms![Form Name]
frm.top = xxx
frm.left = xxx
set frm = nothing

Is there any equivalent method of referencing a query?

Thanks for the help

Tim

 

[Douglas J. Steele]

I don't believe there is.

You could, of course, create a form that returns the results of the query
and control the form.