Insert value into a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top