I wrote an app that scans a barcode and prints to a label printer.
In the beginning, I want to choose which label template/report I want to use from tblReports and set the choice as default until changed by user.
The choice takes place in a frmSetConfig a list box named lstReports that shows all the reports in database
Next open a frmPricePrt where I scan the barcode, and click Print and have it print using the selected template/report (frmSetConfig.lstReports).
This is where I'm lost and could really use some advice.
Do I store frmSetConfig.lstReports as a public variable or to a table or something else? Can I call that variable when I DoCmd.OpenReport "Labels tblScanProd3", acViewNormal
Thanks for reading this
In the beginning, I want to choose which label template/report I want to use from tblReports and set the choice as default until changed by user.
The choice takes place in a frmSetConfig a list box named lstReports that shows all the reports in database
Next open a frmPricePrt where I scan the barcode, and click Print and have it print using the selected template/report (frmSetConfig.lstReports).
This is where I'm lost and could really use some advice.
Do I store frmSetConfig.lstReports as a public variable or to a table or something else? Can I call that variable when I DoCmd.OpenReport "Labels tblScanProd3", acViewNormal
Thanks for reading this