I might be missing something, but I'm finding it very difficult to work with reports in Access. I have searched extensively, but found no clear answer.
I need to be able to change Sort/ Grouping Order dynamically, but it seems that if I try to do this through VBA, it won't let me do so before I open the report because its not open. If I do it after it is open, then its too late. There seems to a be possibility of opening it in design mode, but that seems irrelevant to the user.
I would also need the option of Print Preview and Print. The only way I seem to be able to do this is to have separate command buttons for each which call separate code. I seem unable to bring up the preview and then if the user wishes, then print.
Any helpful pointers would be warmly welcomed.