Re: update Form from query

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

--
Steve Schapel, Microsoft Access MVP

omar wrote:
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
.

Quantcast