Hi,
I want to run a macro (on a form's Close Event), if only a new record has been added.
It's for an Invoice system, and if a new invoice is to be added to frmInvoice, the following macro opens frmInvoice in Data Mode: Add.
Once a new record has been added to frmInvoice, I run another macro called mcrUpdateDiscountRate, that updates a table called tblInvoice.
This macro is called/run on the CLOSE event of frmInvoice.
The problem is, however, that if I want to simply view all my invoices, via frmInvoice, and then close the form...it still runs the macro mcrUpdateDiscountRate.
How can I avoid running this macro, if I'm just viewing all the records in the form (I.e. not adding a new record)?
thanks