I have 2 reports. I would like the user to select a product and the one of the two reports to print based on a field in the source table.
The 2 reports are named
rptMVSalesOrders1
rptMVSalesOrders2
fld1CD is the field in the underlying table
If fld1CD = < 100 then
stDocName = "rptMVSalesOrders1"
DoCmd.OpenReport stDocName, acPreview
else
stDocName = "rptMVSalesOrders2"
DoCmd.OpenReport stDocName, acPreview
Endif
I'm not sure how to get the value of fld1CD