Originally Posted by
Micron
Load event is best for dealing with field/control values. Open is better for things like setting properties on the fly. Using it to set values can raise errors because the form/report is not fully opened until the end of the event. Load event runs after Open event.
You might want to consider setting the report control property to a function that returns the wanted value if you have many of these variations. I figure a Select Case block would be the way to go.
EDIT - can't tell if your sample refers to the main report or sub. Your issue may just be one of improper syntax when referring to the subreport. It depends on whether or not the code is on the sub or the main.
Thanks for your answer, this is a main report that pulls data from a query where the SO is filtered to show the list of items
Code:
SELECT SalesDetail.Product, SalesDetail.Qty, SalesDetail.Notes, Sales.Date, Sales.SO, Sales.SaleType, FROM Sales INNER JOIN SalesDetail ON Sales.SO = SalesDetail.SO WHERE (((Sales.SO)=[Forms]![POS]![SO]));