The query "qrptReversalDietByWeek_Personal_Rationed_Crosstab" had a 2 in the criteria, The criteria needs to be added on all the subreports for whatever is selected in the list box. I have tried everything.
The heading might say 2 on the report but the data does not reflect it. There should only be the three subreports and they should only show one time each for whichever loop is selected.
I don't know what happen, but I went into the crosstab queries and added [Forms]![frmSelectLoopReport]![cboLoop] into the criteria. It created another column in the query that just had the WHERE for the loop and now it seems to be working. Sorry, I'm not sure what I did before but it's working now. Thanks!