Check Box to show on a report

[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

 

[Guest]

Hi Sean

how do i link the "tick" box to each PO.

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.

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