Invoice help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

juped

Thread Starter
Joined
Oct 3, 2007
Messages
8
I've got a form with a command button "print invoice" that prints the shown information as an invoice, the macro 'where' condition code as follows:
[CustomerID]=[Forms]![Customers Order]![CustomerID]
I have a field which is "Invoice printed" yes or no (values 1 and 0 respectively) and i want the "print invoice" command button to change the value of this box to yes once i have clicked on the "Print invoice button. How can i do this? Its so that once i have printed the customers order invoice when i visit the customers orders again i can click this button and only print the orders that havn't been printed before. Any help with the macro which will only print orders with "invoice printed" field = no also appreciated. Any questions please post here if you dont understand, thanks alot.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Are we talking Access here?
If so then if your Form that has the Command button on it also has the field "Invoice printed" you can add this to your Command Button's VBA after the docmd print statement -

me.Invoice_printed = -1.

Yes no check box fields use 0 for not checked and -1 for checked in VBA.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top