I have a form "PriceListPrint" that has a field named "CategoryID" and command button to open a report "PriceListEnglish". In the form before the open report command there is this line: CategoryID="Rest"
In the report there is a subreport "PriceListBeef" that has 2 fields "CategoryIDRest" and
"CategoryIDRest2" I only want to show one or the other, not both, if I manually go into the subreport "PriceListBeef" in the Filter Property and write in either of the controls it works, When I tried to do it in code on the "On Load" of the subreport:
If Forms![PriceListPrint]![CategoryID]="Rest" then
It gives this error "You Entered An Expression That Has No Value"