Apologize in advance.  I have seriously tried to find a solution through the many previous posts with no success. Basically I am trying to build what the invoice app does, for subtotals.

My workflow is to enter a total invoice amount and then split that amount out, using a subform.

So to start, let's say my Invoice total is $5,000

When I enter my first record in my subform (created a subform using another form), I want to pre-fill with Amount = $5,000.  If I need to change it, I can.  Let's say I need to change it to $4,000.

Next, I add a second subform record.  I want to prefill Amount with $1,000 (which is the remaining amount).

when I submit my completed form, I want to check to make sure all the Expense Details = Invoice Amount.

Any help is appreciated.