how to add a query field to a form (1 Viewer)

Mark1982 · Aug 12, 2018

I Cant Add add the query field to a form. i am doing it by control source.
=([Query]![Annual Budget 2018])

its giving me error of (#Name?)

arnelgp · Aug 12, 2018

Use dlookup:

=Dlookup("fieldtoreturn","[Annual Budget 2018]")

Mark1982 · Aug 12, 2018

Dear Arnel,

But my field is in Combo Box. and i want it dsum in my form.

arnelgp · Aug 12, 2018

Add a criteria:

=Dlookup("fieldtoreturn","[Annual Budget 2018]", "fieldname=" & combo)

Mark1982 · Aug 12, 2018

My Combo Box name is Cost Control and the combo box have two fields:
1.By Proponent
2.By Payroll

i want to create a d sum for each one by annual budget 2018.

Mark1982 · Aug 12, 2018

Dear Arnel,
I try it not working.

Please see the below:

table name is: Budget 33101
Field in the Table:
1:Expense Code
2:Annual Budget 2018
3:Cost Control (which is combobox) have two fields 1.By Proponent 2.By Payrol)

now i want to make dsum for each field of combo box to show me total of annul budget 2018.

arnelgp · Aug 12, 2018

There is no proponent or payroll code in the table.

Mark1982 · Aug 12, 2018

Yes in previous there was no combo box but they told me to add. so i add it.

Mark1982 · Aug 12, 2018

Dear Sir Arnel I send you my updated database in your email.

how to add a query field to a form (1 Viewer)

Mark1982

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Mark1982

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Mark1982

Registered User.

Mark1982

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Mark1982

Registered User.

Mark1982

Registered User.

Similar threads

Users who are viewing this thread