Updating records from a form

hullstorage

Registered User.
Local time
Today, 10:21
Joined
Jul 18, 2007
Messages
213
I have a form that shows me all invoice numbers that have not been invoiced and a command button to the right of the invoice number that prints the invoice

but what i am trying to do is when i have printed the invoice for the given invoice this is then updated to Invoiced=Yes

here are the fields i am working with on the form

customer JobNumber invoicenumber jobdetails cost invoiced ( yes/No )

so currently when i print the invoice the invoiced field still remains = No

bare in mind that i need this to happen to the selected invoice number on the form

thanks
 
On the button that you press to print out the invoice, immediately after the print command, place this code:

Me.Invoiced = -1
 

Users who are viewing this thread

Back
Top Bottom