I am trying to use a Case Select to determine whether to use DoCmd.OpenReport or DoCmd.OpenForm. If case 1, OpenReport, if case 2, OpenForm.
I can get it to work with the report/form name but not the actual DoCmd.Open. Something like:
Code:Case 1 formtoopen = DoCmd.OpenReport "rptActionNeeded" Case 2 formtoopen = DoCmd.OpenForm "frmSchedulerRoutine"