I cannot update a table from a form

  • Thread starter Thread starter JoAnne
  • Start date Start date
J

JoAnne

I have created a table that will be updated by using the
calculations within a form. When I put in a few of the
fields in the form to perform the calculations, it works.
However, when I go into the table only the fields that I
manually put in are there, not the calculated fields. I
used the "setvalue" macro command several different ways
and still no luck. Within the form itself I have the
calculations, so I have to just have the calculations in
the macros in order for them to work. I've used the table
to update the item and the form field name for the
expresssion and vise versa. Is there a simpler way to
update the table after the informaion has been entered???
 
If the value can be calculated in a form or report then
it's redundant to keep it in your table at all.

For Example: In one of my databases, I have a SalesTotal
table where I track SalesID, SubTotal and SalesTax but not
the SaleTotal since I can always calculate it whenever I
pull the data.

I'm not sure why your form isn't working. If the control
with the calculations bound to the field in your table?

You might want to use an UpdateQuery. Open the form,
enter your data, run UpdateQuery to do your calculations.
(If you need to, check the Help files for the specifics).

Hope this helps!

Howard Brody
 
Back
Top