Displaying a SUM from one form into another form

[ortizimo]

One table has a sum that I want to display into a form not of that table if that makes sense. I'm using this which errors out:



=Sum([tbl_Commission].[Commissions])

also used:
=DLookUp(=Sum([tbl_Commission].[Commissions]))

Again, trying to display a total SUM from a form into another form.

[pbaldy]

Presuming the first form is open, simply refer to the control:

=Forms!FormName.TextboxName

[ortizimo]

Presuming the first form is open, simply refer to the control:

=Forms!FormName.TextboxName

and if its not, how can i pull the info from the tbl or qry into a form?

[pbaldy]

One way would be a DSum() with the same source, or an appropriate criteria.

DLookup Usage Samples

[ortizimo]

One way would be a DSum() with the same source, or an appropriate criteria.

DLookup Usage Samples

This is what i tried which did not work:
DLookup("txtIncome", "tbl_Commissions", "Sum = " & forms!frm_Commission!txtIncome)

[pbaldy]

Is txtIncome the name of the field in the table you want summed? It needs to be. Also, "Sum" needs to be the field you want the criteria applied to, and the form reference would refer to a control containing the value to filter on.

[ortizimo]

Is txtIncome the name of the field in the table you want summed? It needs to be. Also, "Sum" needs to be the field you want the criteria applied to, and the form reference would refer to a control containing the value to filter on.

yes it is the name of the field in a form...could you use my code above and correct it? thnx.

[pbaldy]

Let's clarify. Forms have controls (textboxes, combos, etc); tables have fields. In the first argument, you want the name of the field in the table, not the name of a textbox on a form. Did you study the link I posted?