At the click of the button I need to run code that will take value from combo box and base don the value will select dtat for the report.
Main table that contains data is created by running MakeTable query.
If I uinclude MakeTable query into code as
then table Make_School_Report will stay open and never close.
How should I make this table so it will not interfere with anything? Run Macro in code? DoCmd.OpenMacro etc...