Sum query results on Continuous form

[mjcaestecker]

Greetings all,

Here's some background on the issue:
I have a form with 2 combo boxes. Each combo box has a list of cities in it. I have a query (MilesQry) that looks up the number of miles between the cities from a table.

the form is continuous, so you can add multiple records to see how many miles are between many pairs of cities.

here's the problem:
I cannot find a good way to sum up the number of miles from all segments to get a total mileage.

What I've tried so far is to have a text box which uses a DLookup to query the number of miles from the results of the two combo boxes and display it in a text box (NumberOfMiles). Then I tried to use a text box with =Sum([NumberOfMiles]) to sum all of the mileages together, but it keeps returning #Error.

Any Thoughts?

-Martin