Update field from a query

dealwi8me

Registered User.
Local time
Today, 02:06
Joined
Jan 5, 2005
Messages
187
I have a field in a form and i need to fill this field with a query value.

I created the query and i added it at Field properties ->Defaul Value as follows: [qrySUMApprovedArea]![SumOfApprovedArea] but i get no values at the field.

If i set Form Recordsource to the query then i get a non-updatable form.

Any suggestions? :confused:

Thank you in advance!
 

Users who are viewing this thread

Back
Top Bottom