If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Check Box to show on a report
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 |
#2
|
|||
|
|||
Check Box to show on a report
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 -- Wayne Manchester, England. Enjoy whatever it is you do "SeanE" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|