Selecting Checkboxes

  • Thread starter Thread starter So-Ange
  • Start date Start date
S

So-Ange

I have a report that has 4 check boxes. I can preview the current
report fine. What I would really like is to Preview the 4 copies of
the same report and each copy have 1 chk box per copy. copy1=Seller
check
copy2=Owner Check
copy3=Purchasing check
copy4=Accounting Check
Then hit the print button.
Right now my print button prints the 4 copies w/o the checks on click
then it previews. Help!!!!
 
I'm not completely clear on what you are doing, but it sounds like you are
trying to use checkboxes on a report ... and if I recall correctly, you can
see them, you can react (in code) to the values there, but you can't "check"
them.

Have you considered using a form (with your checkboxes) to "order" your
report?

Or have I misunderstood what you are trying to do?
 
I am not sure how to go about this: The concept is like carbon-less
copies. Since the person signing checks the boxes manually to avoid
that the boxes will be pre-checked at print there will be no need to
manually check the 4 boxes.

I hope there is a way.
 
Sorry, but I'm still confused.

Could you describe what you are trying to accomplish as you might to an
80-year old grandmother? Don't include any "how" in your description...
 
I have a report and at the bottom of the report I have 4 check boxes
chkSeller, chkAcknowledgement, chkPurchasing and chkAccounting.
I now have it printing four copies of the current record. I will also
like the 1st copy to check chkSeller on print and so forth. that way
there is a check box for each print already checked..

hope I made I made it clear.
Thanks!
 
I'm not aware of a way for Access to track how many copies are printed
(there may be a way, but I don't know about it). I suspect it is a function
of the print-spooler, rather than Access.

Another approach might be to use code behind a form to send four distinct
OpenReport commands, each one setting an indicator on the form (hidden
controls would work) for which checkbox on the report gets checked.
 
PMFJI,
I would try create a table of copies "tblCopies" with two fields
[CopyNumber] and [CopyTitle].
1 Seller
2 Acknowledgement
3 Purchasing
4 Accounting

Add this table to your report's record source but don't join it to any other
table. Then set your first sorting and grouping level to [CopyNumber]. Add a
copynumber footer with an option group bound to the CopyNumber field. Your
option group would be basically the same as the records in your tblCopies.
 
Back
Top