OK - I've got the VBA for marking everything as billed...
But now I'm trying to do more coding so that some calculated values in the form store to my parent table (Invoices form, it pulls in values from three different subforms to a total - I want to be able to store that value in the invoices table.)
I have a command button where on click it does:
Code:
CurrentDb.Execute "Update Invoices Set Amount=" & Me.Amount
CurrentDb.Execute "Update Invoices Set Province=" & Me.Province
CurrentDb.Execute "Update Invoices Set GST=" & Me.GST
CurrentDb.Execute "Update Invoices Set Provincial_Tax=" & Nz(Me.Provincial_Tax, 0)
But this updates every single Invoices record, not just the Invoice_ID associated with the current form.
Any help with the code to isolate the Update to only the current Invoice_ID would be appreciated.