W
WoodyAccess
I have 2 similar reports which are requisition orders.
Report "POR" is a report that displays Order and OrderDetails information,
report "POR_Thread" is the same form but has the addition of after every
order detail it displays thread information (if the category ID is thread). I
have one cmd button on my main orders form that links to view reports in
Print Preview.
When my subform Category control = 1 (thread), I want the report
"POR_Thread" to display the information and to be filtered by just the
"PurchaseOrderNo" displayed in the main form (i haven't set up a filter yet
so if needed I'd like to be told how to do that as well).
If my Category control = 2, 3 or 4 I want the report "POR" to display the
information
Report "POR" is a report that displays Order and OrderDetails information,
report "POR_Thread" is the same form but has the addition of after every
order detail it displays thread information (if the category ID is thread). I
have one cmd button on my main orders form that links to view reports in
Print Preview.
When my subform Category control = 1 (thread), I want the report
"POR_Thread" to display the information and to be filtered by just the
"PurchaseOrderNo" displayed in the main form (i haven't set up a filter yet
so if needed I'd like to be told how to do that as well).
If my Category control = 2, 3 or 4 I want the report "POR" to display the
information