Hi everybody,
At the moment I have a form based on a table and a subform based on a query linked to a different table. The linked field is BRAND - so when the brand changes in the main form, the BRAND in the subform will change and brand specific numerical data will be brought up in the subform.

Anyway, this brand specific data is then passed to 4 fields in the main form. The main form has a final field which takes the values from the 4 other fields and SUMS them.

My question is this:

I would like to be able to view the main form in DATASHEET view. However, when DATASHEET view is brought up, the fields which should be calculated from the sub form display #ERROR. Clicking on the +sign in the first column allows these to show, but it is inconsistent across the rows ie. #ERROR sometimes displays after clicking +, and sometimes the correct values display.

I have checked the main form and the correct values always display fine when in FORM view...

I know I can build a report and pass the same data to Excel - this will work. However, I am building this for my wife and she insists on having the data display in DATASHEET view from the form.

Can it be done!?

Thanks in advance
!!!
Andrew

Hi, Andrew, and welcome to P2P.

If you have a subform embedded in the main form, you cannot show the main form in datasheet view. The subform will have no way to manifest itself and therefore, you will get errors in those calculated fields which depend on the subform for information.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division