Public Function fCalc_Items Table not updating form.

[Battlescar]

Hi
I was wondering if someone can help me with my problem. It seems when I update a table(tblSurveyListsub) for the form(frmEQ_EQCollectionbyMonthApprov) it does not update. But if I use the table (tblSurveylistSubold) rename to tblSurveyListSub the form calculates and works. I am going crazy to find out why and how to fix it. I have attached the database for whoever to look at. It runs from Module1 in the form (frmEQ_EQCollectionbyMonthApprov).

[June7]

All you are doing is calling function in a textbox expression to calculate a value. Saving that calculated value to table requires more code - VBA or macro. Such as:

Me.fieldname = Me.textboxname

Real trick is figuring out what event to do this in - perhaps the Close Form button click.

Saving calculated data, especially aggregate data is usually a bad idea.

[aytee111]

Need more information. This seems a very convoluted method for getting to the values to display. Each section could be a subform with the values already calculated, linked by year. I could not see where you are updating a table.

[Battlescar]

Need more information. This seems a very convoluted method for getting to the values to display. Each section could be a subform with the values already calculated, linked by year. I could not see where you are updating a table.

Sorry I am not really updating a table. If I replace the data in the table or insert new data into the table it doesn't work. The form works fine if you use the old table.

[Battlescar]

I am not updating any table. Bad choice of words. If I replace the data in the table which I did in this example it does not work. But If I use the tblsurylistsubold the forms calculates and work.

[aytee111]

Looking at the surface, there doesn't seem to be any data to be displayed. I would highly recommend doing this a different way, to keep it simple.