I was wondering if it is possible to include code into one of my command buttons to have it look at the status of a yes/no option for which report to open. Currently, I have a report which summarizes all animals in a given date range. I would like to add a checkbox that when activated will open a different report that has just the summation of the numbers (# of procedures, total amount, etc) versus when the checkbox is not activated - then it would open the by-animal summary.
Is that even possible? Or should I just make another command button to open the different report.
If [Forms]![Welcome]![CheckSum] = True then DoCmd.OpenReport "QRptAll" Else Do.Cmd.OpenReport "QRptSummary" End If