Where Condition written on the report
How can i write the where condition on a text box in a report?
I am opening the report with the help of a combo box and the
following where condition:
View:=acPreview, WhereCondition:=”OrderID > ” & Me![CboOrders]
Can i add on a control on the report saying that this is a list
of all orders greater than the order selected in the combo box?
What i have tried is :
=”List of all the orders greater then : ” & “” & Forms!MyForm![CboOrders![orderid]
But i am afraid it doesnt make sense
