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
|
|||
|
|||
Access 2007 Form information not appearing in associated Table
Have created various expressions in different fields of a Form. The
expressions function correctly in the Form, outputing the correct information. This information in the Form fields do NOT appear in the Table from which the Form was created. If the expressions in the Form fields are removed and the data inserted manually in these fields, the data then appears as it should in the Table as it does in the Form. Another strange thing occurs when I use the same Table to generate a Split Form, as in this case, all the datta appears in the Table half of the Split Form, but not in the orignal Table from which the Split Form was generated. Could anyone please help as I tried all options - re-generating the Form and Table, with no success. |
#2
|
|||
|
|||
Access 2007 Form information not appearing in associated Table
On Wed, 31 Dec 2008 10:13:01 -0800, MDS_frustrated wrote:
Have created various expressions in different fields of a Form. The expressions function correctly in the Form, outputing the correct information. This information in the Form fields do NOT appear in the Table from which the Form was created. If the expressions in the Form fields are removed and the data inserted manually in these fields, the data then appears as it should in the Table as it does in the Form. Another strange thing occurs when I use the same Table to generate a Split Form, as in this case, all the datta appears in the Table half of the Split Form, but not in the orignal Table from which the Split Form was generated. Could anyone please help as I tried all options - re-generating the Form and Table, with no success. Controls on forms are either bound to fields or to expressions. Only controls bound directly to fields have their data written to the table. Think of it this way. If the ControlSource property is defined as "what field does my data go to" then a ControlSource that is not the name of a field has nowhere to go. The good news is that data based on expressions are not supposed to be stored in your table anyway. Just use the expressions any place you need them and delete those fields from your table as you don't need them. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Access 2007 Form information not appearing in associated Table
This question was asked and answered... and so you don't have to go looking
for it... Access is working correctly. A calculated result is NOT stored in a table. Why would you want it to? That resulting value might be correct today, but it will certainly be incorrect tomorrow. Besides, using your expression, into which field should Access store the value even if it could? Instead of trying to store that value, anytime you need the result of that calculation, re-calculate it, either on the form or report, or in a query. By the way, your expression could cause confusion further down the road. In Access, -1 is True (not 1), so someone reading your code in the future may very well be confused when trying to further use the calculated results. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "MDS_frustrated" wrote in message ... Have created various expressions in different fields of a Form. The expressions function correctly in the Form, outputing the correct information. This information in the Form fields do NOT appear in the Table from which the Form was created. If the expressions in the Form fields are removed and the data inserted manually in these fields, the data then appears as it should in the Table as it does in the Form. Another strange thing occurs when I use the same Table to generate a Split Form, as in this case, all the datta appears in the Table half of the Split Form, but not in the orignal Table from which the Split Form was generated. Could anyone please help as I tried all options - re-generating the Form and Table, with no success. |
Thread Tools | |
Display Modes | |
|
|