Dsum criteria

[Manuel Ferreira]

Good Morning



I will try to explain what i want.

I have a form that has the following fields:

Field1: Familiar: a dropdownlist with names

Field2: Valor apresentado : a currency field

Field3: Total apresentado ate a data: (A calculated field, currency)

In each record I'm placing an amount in field2 to a given name in field1.

In field3 (Total apresentado ate a data) i want the total amount of money given by "name"

I've written the following statment in "After update" of field2

Private Sub Valor_apresentado_AfterUpdate()

DoCmd.RunCommand acCmdRefresh


Dim nome As String


nome = Me.Familiar




Me.Total_comparticipado_até_à_data = DSum("[Valor apresentado]", "[livros]", "[familiar] = " & nome)

I've tried several things but it didn't work

could you help please
Best Regards

manuel

[ranman256]

Build a query that sums the values via person.
The form is connected to this query.
When the user picks the person out of the combo , refresh the form filter.
then all the fields will populate.

cboPerson_afterupdate()
Me.filter = "[personID] = " & cboPerson
me.filteron = true

[Manuel Ferreira]

Thanks for the answer

I've already builded the query what i dont know is how to connect the form to the query and at the same time fill the original table?

Also maybe i didn't explained well what i want:

I'm getting invoices from my associates, i'm getting from each the mane and the ammount .
I need To control the amount (to further calculations) that each associate presents.

Best regards

[ranman256]

In the form design, in the properties
data tab, set the record source to the query you want to see.

Then You can enter data from the associates
or paste it in the form
or import it via XL or text.

[Manuel Ferreira]

Ok, Thanks