To use a command button to open a report, do the following:
1)Select command button from the toolbar and place it on your form;
2)Right click on command button and select "properties";
3)In the command buttom properties window, go to "On Click", and select "Macro Builder."
4)Once you are in the Macro Builder screen, on the first line, select "Run Command." At the bottom of your screen you will then seen a single field drop-down - scroll down until you find "Refresh" - select it.
5) On the second line in your macro, select "Open Report." Once you have done this, go again to the bottom of the screen, and follow the prompts for each field. It will ask you for the report name, and filter/qry used for the report. Answer all the questions, then save your macro.
6) Exit out of the macro builder, and give it a try.