Insert value into a form

[Guest]

I am trying to insert a numeric value into a field on a form via a sql query.
The query totals up all the cost fields asociated with a particular record.
The query say brings up a figure of 400 but i cant get this figure to insert
into the form field.

cheers

Nick

 

[Guest]

Is the form based on that query? That is to say, on the properties box, is
this where the form is getting its data?

You may need to add a sub-form that is based on the query that does the
totaling--it can be a very small sub-form. That's how I've done similar
things, though someone else may have a better solution.