Pick any table with a dozen or so fields and use them to create a test query. Include all fields in the order they occur in the table. Now run the query, or just request datasheet view. Now move some columns around, hide a couple, and change the width of a few. Make a useful view of the data. Save your query. Now open it. How nice. The view is how you get to see your datasheet.
This is useful when you run a query inside a subform control without creating a form. Just set the sourceobject of the subform control like so: me.yoursubformcontrol.sourceobject = "Query.NameOfTheQueryYouCreated". The leading Query. part of the string has got to be there. Voila, your datasheet appears with the view you created.
All this is very handy.... BUT, how do you GET RID of this view that has bound itself to your query? I haven't figured that one out and I really need to know. And just as an aside.... where the heck is this "view" being stored by Access anyway?
Anybody?