update Form from query

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

Guest

I am access beginner. I would like to show the result of query on form. I pu
the query name on the control source of the text box but it didn't work.

controlsource =totals!total

the query basic sum the tolal of field
 
Omar,

Try it like this...

In the Record Source property of the form, put the name of the query.
For example:
totals

In the Control Source property of the textbox, put the name of the
field. For example:
total
 
Back
Top