Getting form expression results to update to table.

  • Thread starter Thread starter Peg
  • Start date Start date
P

Peg

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