The totals from the expressions in a couple fields on the form don't update 
to the table.  They (the expressions) work correctly in the form, but they 
(the results of the expressions) don't appear on the table after clicking 
Update All.

Does anyone know how ot fix this?

Hi Peg,

First, forms don't contain fields.  They contain controls (most commonly 
textboxes) which may or may not be bound to fields in the form's 
recordsource.  If they are bound to a field, changing the data in the form 
will change the underlying field in a table (unless the form's recordsource 
happens to be a non-updateable query).

Alternatively, a textbox on a form can display the result of a calculation 
(usually involving other fields from the form's recordsource).  A textbox 
cannot contain a calculated expression and be bound to a field.  And, in 
almost all cases, you should not be storing calculated fields in your 
tables; simply display the calculation in a control in your form or report.

HTH,

Rob

"Peg" <Peg@discussions.microsoft.com> wrote in message 
news:9DB3C495-C45C-463B-9BFE-49FEB7DDC0CD@microsoft.com...
> The totals from the expressions in a couple fields on the form don't 
> update
> to the table.  They (the expressions) work correctly in the form, but they
> (the results of the expressions) don't appear on the table after clicking
> Update All.
>
> Does anyone know how ot fix this? 

Hi Rob...

Thanks for the explanation.  I'm brand new to this process and I'm learning 
as I go.  Your reply "A textbox cannot contain a calculated expression and be 
bound to a field." would have been useful information in the Help file.  :-)

I was sort of using the Table like a spreadsheet, but now that I understand 
the process better I see they're not interchangeable.

Thanks, yes, your explanation did help.

Peg 

"Rob Parker" wrote:

> Hi Peg,
> 
> First, forms don't contain fields.  They contain controls (most commonly 
> textboxes) which may or may not be bound to fields in the form's 
> recordsource.  If they are bound to a field, changing the data in the form 
> will change the underlying field in a table (unless the form's recordsource 
> happens to be a non-updateable query).
> 
> Alternatively, a textbox on a form can display the result of a calculation 
> (usually involving other fields from the form's recordsource).  A textbox 
> cannot contain a calculated expression and be bound to a field.  And, in 
> almost all cases, you should not be storing calculated fields in your 
> tables; simply display the calculation in a control in your form or report.
> 
> HTH,
> 
> Rob
> 
> "Peg" <Peg@discussions.microsoft.com> wrote in message 
> news:9DB3C495-C45C-463B-9BFE-49FEB7DDC0CD@microsoft.com...
> > The totals from the expressions in a couple fields on the form don't 
> > update
> > to the table.  They (the expressions) work correctly in the form, but they
> > (the results of the expressions) don't appear on the table after clicking
> > Update All.
> >
> > Does anyone know how ot fix this? 
> 
>