In design view (I think), the query is run to get the available fields so you
can select them for the source of the controls. This is especially true if you
are using a cross-tab query.
One thing you can do is to pre-define the fields that are returned by the
crosstab query.