If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculations in form are not entered into appropriate table
Calculations entered into property control source is not entered into the
appropiate table field. Show up as $0.00 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
You don't store calculations in a table. What if one of the fields that
makes up that calculation changes? How would access know to update the calculated field? When you need the calculated value, claculate it in your form, report, or query. For more details, read the previous posts on the topic. This is asked and answered all the time. Do a search. -- Rick B "TLM_QA" wrote in message ... Calculations entered into property control source is not entered into the appropiate table field. Show up as $0.00 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to clear controls of Filter form | Jan Il | Using Forms | 2 | November 28th, 2004 03:04 PM |
Default values to load up automatically in a form based on value entered in another form | Anthony Dowd | Using Forms | 8 | August 12th, 2004 08:53 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |