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
|
|||
|
|||
Changing Field values after a report is printed
Tim -
You can update the field when the user clicks the button to print. If the field is not on the form, add it (you can make it not visible if you don't want the users to see it). Then in the code behind the Click event of the print button, add something like this (use your control name): Me.DeliveryPrinted = True Me.Dirty = False ' to save the record. -- Daryl S "TimJames" wrote: I have a form that is filled out by a user for deliveries, one product per entry. The users may create several entries for different products for delivery to various areas. After the form is filled out a button is clicked that generates a report to print out for obtaining signatures for delivery. Is there a way to also change the value of a field in my table to indicate that the delivery / form has been printed? I need this as sometimes a second delivery for that day may be needed and I do not want the deliveries that have already been made to be printed again. Thank you, ~Tim |
Thread Tools | |
Display Modes | |
|
|