I have the table that holds batch numbers and the date and time batches were created. But no, I don't need to know when the labels were printed, just IF they were printed, which is what the ysnLabels field is for. Basically, I need to know, if the user wants to print three pages of labels, for example, how to select three batch numbers (I am guessing maybe a GROUP BY sql) and load only those batches to the rptLabels to print. Then after printing...

One major function of my database will be to print labels to be used for solicitation. Not all labels will be printed at the same time and I need a way to not repeat printing. I have little experience in VBA and I'm sure there is a better, quicker way to do what I've managed to do thus far. But I am stuck on how to finish this out.

Database Structure:
tblCo with fields: pkCoID, strCo, strAddress, strZip, fkBatch, ysnLabels...