form / query relationship

[ariansman]

There is a query named query1, which has a column named “salary”.
We also have a form with a textbox named “payments”.
Can we design the form so that when it is loaded the textbox named payments gets the sum of column salary of query1?
I mean: “payments” in form textbox = sum of “salary” column from query1

[June7]

Query1 is not the form's RecordSource?

Could use a domain aggregate function (DLookup, DSum, DMax, etc.) expression in textbox.

[ariansman]

Query1 is not the form's RecordSource?

Could use a domain aggregate function (DLookup, DSum, DMax, etc.) expression in textbox.

the form is not made on query1.

can you help more about the expressions? i mean how can i write them and make them use query1?
thank you

[June7]

Review http://rogersaccessblog.blogspot.com...mystified.html

[mitch_pearce79]

Dsum(“Payments”, “query1”, criteria)
Criteria might be:
“PersonID = “ & me!PersonID & “” if the payment sum is related to a person (PersonID) on frmPerson
What is your main form based on?