Access 2007 Form information not appearing in associated Table MDS_frustrated 12/31/2008 6:13:01 PM 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.

Re: Access 2007 Form information not appearing in associated Table Rick Brandt <rickbrandt2[ at ]hotmail.com> 12/31/2008 6:27:58 PM On Wed, 31 Dec 2008 10:13:01 -0800, MDS_frustrated wrote: [Quoted Text] > 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

Re: Access 2007 Form information not appearing in associated Table "Gina Whipp" <NotInterested[ at ]InViruses.com> 12/31/2008 6:29:49 PM 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" <MDSfrustrated[ at ]discussions.microsoft.com> wrote in message news:A3CB5114-BFC8-4534-BFC9-787F65BDEEB3[ at ]microsoft.com... [Quoted Text] > 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.