Total on a sub form

[Guest]

Hello
I'm no expert on access but i know a few things.
Here's my problem and I thought i knew how to sum a field called "Valor" on
a simple subform. I've tried everything and it didn't work. Here an example :
=Soma([Formulários]![Formulario Principal]![Valor])

Any ideas?
Tks in advance
Pedro

 

[Guest]

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

notice the extra .Form! after the subform name

 

[Guest]

Hey Beetle
Tks for your answer
I did want to sum although the formula is in portuguese it's be sum( ...?
right?
Tks in advance
Pedro

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

notice the extra .Form! after the subform name

Hello
I'm no expert on access but i know a few things.
Here's my problem and I thought i knew how to sum a field called "Valor" on
a simple subform. I've tried everything and it didn't work. Here an example :
=Soma([Formulários]![Formulario Principal]![Valor])

Any ideas?
Tks in advance
Pedro

 

[Guest]

Honestly, I have no idea how VBA code translates in portugese.

Hey Beetle
Tks for your answer
I did want to sum although the formula is in portuguese it's be sum( ...?
right?
Tks in advance
Pedro

To refer to a control on a subform, use the following syntax:

Forms![main form name]![subform control name].Form![control name]

notice the extra .Form! after the subform name

Hello
I'm no expert on access but i know a few things.
Here's my problem and I thought i knew how to sum a field called "Valor" on
a simple subform. I've tried everything and it didn't work. Here an example :
=Soma([Formulários]![Formulario Principal]![Valor])

Any ideas?
Tks in advance
Pedro