Check Box to show on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 question here the first is i have a form of purchase order numbers
that i filter to find, i have a check box against them, for me to "tick" to
show the order has been sent, how do i link the "tick" box to each PO.
Also once "ticked" i need this tick to show on a report that shows all the
orders in a list and all orders that have been sent.
Thanks
Sean
 
Hi Sean
how do i link the "tick" box to each PO.
Click to expand...

You could place a Yes/No field in the table storing the Purchase Orders.
When check on you form the data would be stored in the table.

Also once "ticked" i need this tick to show on a report that shows all the
orders in a list and all orders that have been sent.
Click to expand...

Insert the Yes/No field into your report. To have a list of sent orders and
a list of unsent you can use the Sorting and Grouping option. You could
alsouse this same option to show a group footer into which you could place
the totals for each group.
If you don't like the checkbox you could set it's visibility to No and
insert an unbound textbox and use this is it's control source
=IIf([CheckBoxName]=-1,"Order Sent","Order Not Sent")

Hope this helps
 
Back
Top