[AccessD] Subform Errors

List,

I have an Access 97 database and am having a problem with a
form/subform.  The main form holds data for the parent record and the
subform shows data for the child records for the parent; a typical
design.  The subform is based on a semi complex query that has some
calculations in it that sum some cost fields for each record.  There are
several hidden calculated text boxes on the subform that perform further
data aggregations for several fields from each record.  I refer to these
fields in controls on the parent form to show their value.  Hopefully
this description isn't too confusing.

The problem is that the forms work correctly when the main form is first
opened in design view and then switched to form view.  When the form is
opened in this fashion and a record selected from a selector combo box
all fields function and calculate correctly.  If the main form is opened
directly to form view and a record selected the calculated controls
contain "error". If I then switch the form to design view and back to
form view it works correctly.  There is very little code behind these
forms and nothing on a form event except docmd.maximize on form
activate.  This is the first time I have run into this situation.  Why
would the form behave differently based on whether it was first opened
in design view or directly into form view?

Doug