DataSheet Sumary

[cparralesl]

Hi Guys/Girls,

Access 2007

I have a Datasheet form into another as a subform

I have a sumary texbox unbound in the first Datasheet, that takes the its value from another unbound texbox placed into the subform. This works just fine.

The problem I need to solve is the sumary. This shows the value until I click on the plus sign ("+") meanwhile it shows and error (#Error). I need the sumary textbox recalculates its value always.

As usual I will appreciate your helps

Regards,

Cesar Humberto Parrales
Application Support

 

[cparralesl]

Hi Againg guys,

I´ve tried both ways:
=Forms!FormName!SubformName.Form!txtTextBoxName
=Forms!FormName!SubformName!txtTextBoxName

and they are giving me the "#Error" text instead of the sumary amount.

As I said, the error message gets off and It shows the right amount after I click in the "+" sign of the DataSheet.

Please I need to solve this. I have made tests too without sucess. :-(

I do not understand why the error comes up if I click directly in the forms name in the Access toolbar. If I click in the view option in design mode, the error disapear and the sumary is shown.

Many thanks for yours feedbacks

Regards



Cesar Humberto Parrales
Application Support