use code to recalc values in a table

LGarcia · Jul 16, 2004

Hi All,
I have a form based on a table. I have a button on that form that triggers
code (lots of code) which evaluates the data displayed for each record and
calculates a value. I need to export this table. Before I export I need to
recalculate values. Is there a way to apply the code I used from my button
to the table without opening the form?
TIA,
LGarcia

Wayne Morgan · Jul 16, 2004

You will need to open something other than the table to run the code. It
could be another form that only does the export, if you wish. Also, you
could do the table export in code after doing the calculations, if that
helps.

LGarcia · Jul 19, 2004

Thanks! This will do it!

Wayne Morgan said:
You will need to open something other than the table to run the code. It
could be another form that only does the export, if you wish. Also, you
could do the table export in code after doing the calculations, if that
helps.