Hi, can someone tell me if there is a way to save several different datasheet views? I have a large database with many fields. I use forms for data entry, but to view the data I use the table datasheet (so I can see multiple records at a glance). But every time I have to manually move, freeze, and hide columns to get the view I want!! Is there a way to save several different datasheet layouts that I can access the view I want with one click? because I am tired of freezing/hiding columns every single time.

Many thanks

man, I'm THICK....

I just figured it out, never mind!

Not sure what you figured out, but generally they are called queries ;)

Hi, can someone tell me if there is a way to save several different datasheet views? Since you shouldn't be working directly with datasheets, you can create several forms that LOOK LIKE datasheets. You can show/hide/freeze columns as you need and save multiple forms if you want multiple configurations. This has the added advantage of having more than one view open at the same time as well as providing events in which to place code.