Calculated control on Continuous Form

[Mtyetti2]

I am trying to add a calculated control into a continuous form for each record. Basically it is a mileage total. I am using an unbound text box with the following data source:


= [Event]![MileageIn] - [Event]![MileageOut]

When I run this in form view, I get a "#Name?" error.

I'm hoping this is a simple fix. Any help is much appreciated.

[June7]

Are MileageIn and MileageOut fields in the form's RecordSource?

= [MileageIn] - [MileageOut]

[Mtyetti2]

No, but it is now. That solved it. Thank you so much, june7!!