Total on a sub form

P

Pedro

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
 
B

Beetle

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
 
P

Pedro

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

Beetle said:
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

Pedro said:
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
Click to expand...
Click to expand...
 
B

Beetle

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

Pedro said:
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

Beetle said:
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

Pedro said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top