View Single Post
  #2  
Old May 9th, 2005, 02:35 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

TLM_QA wrote:
Calculations entered into property control source is not entered into
the appropiate table field. Show up as $0.00


A control is bound to a field in the table by entering a field name (and
just a field name) as the ControlSource property of that control. If you
have entered an expression as the ControlSource then it is no longer bound
to a field and there is no mechanism to get that value stored into the
table.

The good news is that calculations are not supposed to be stored in your
tables anyway. Just use the calculation that you already have on the form
anywhere you need that value displayed. If you don't want to enter the
expression multiple times then build a query based on your table and add the
expression as a calculated field in the query. Then just substitute the
query every place that you ordinarily use the table.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com