I have an Orders form with a Orders Detail subform. I have added a status Yes/No field so that the user can select which items can be invoiced.
Clicking on the invoice button will create an invoice report for that record only. Once invoiced, I need to have a 2nd Yes/No (named Invoiced) be automatically updated to YES so that the same line is not invoiced at a later date.
How can I make this happen?
I started using Access in Version 2.0 but havent used it for 20+ years.