Doug Murphy
doug at murphyscreativity.com
Sun Jun 22 13:30:53 CDT 2003
Hi Jim, There are records. I have been doing the tests on the same data. The only difference in is how I originally open the form, design view and then form view, or directly to form view. I am puzzled by the different behavior in what should be the same thing. I have gotten some ideas from the list to try. If all else fails may have to take Gustav's advice and do it all through calculation in code. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Sunday, June 22, 2003 5:33 AM To: accessd at databaseadvisors.com Subject: RE: [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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com