i set your form to open when access starts up: menu, tools, start up.
i set the ok button's macro to open your report (this is my first time playing with macros, kinda screwy if you ask me)
i was trying to get a macro to close the form when the report opened. this seemed to take place before the reports recordset populated, so i dropped it. users will just have to hit cancel or X. you could also set the form to close with the reports close event if you wanted to make it easier.