[AccessD] Subform Errors

Doug,

  Something else that you need to be aware of: When a subform (or report)
returns no records, Error is displayed in all the controls that reference
it.

  It's not clear from your description of the problem if your seeing records
or not when you get the Error's

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Doug Murphy
Sent: Saturday, June 21, 2003 7:11 PM
To: accessd at databaseadvisors.com
Subject: [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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com