Updating records from a form

[hullstorage]

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

 

[missinglinq]

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

Me.Invoiced = -1