Hiding query columns

[arage]

Hiding query columns
How can I hide query columns in using a macro? Please advise.

 

[boblarson]

When you say "hide columns" what do you mean? Where do you mean? I think we need a few more details of what you're trying to accomplish.

Awaiting further instructions -

BL

 

[arage]

hey thanks, I just wound up creating a query to suit my needs, and I meant hiding columns in the query. Right now though what I’m doing is:
-running macro to open query
-going to the bottom of query
-going to a field called dealerNumber
-microsoft shortcut key / filter by selection
-going to dealerStore field and populating it
-closing query
-go back to first step

 

[boblarson]

I usually will keep the query as is, and create a Form (Datasheet mode) to view what I want people to view. That way, you don't even have to leave all of the columns in, but you can make it look like they're actually viewing the query when in fact they're viewing a form.

BL