Form set to show Continuous, not Single. Two totals are displayed. The first is a sum from a many-to-one table (a drill-down button takes you to the details). The other is the first total plus a user-entered amount.
EXAMPLE: Orders for items being purchased. The form shows one record for each order, continuously. Each record (each order) shows the total purchase price as a single figure, and a final billing amount which is the purchase price plus shipping cost. There is a field for entering that cost. User enters a value for Shipping and sees the final billing amount update on the form.
WHAT HASN'T WORKED:
My latest attempt used a DLookUp() in the field for final billing amount. But I couldn't see how to set the criteria (order number) as part of the function. Got "#Name" whenever I switched from a simple numeric value to a reference to the current order number.
I've tried the same thing using VBA to populate the field (updates on Form_AfterUpdate or some such).
One standard approach is to use a subform to roll up totals, but that doesn't work with continuous forms.
I suspect the continuous form is the problem with all these approaches.
WHAT I STILL HOPE TO AVOID:
Two subforms, one updateable and one for totals, with Requeries sprinkled around the form/control events.
How can I do this?
[purple]_______________________________
Never confuse movement with action -- E. Hemingway [/purple]
