Update a table from a form

  • Thread starter Thread starter jimp
  • Start date Start date
J

jimp

I have a calculated value in a form, and cannot for the
life of me get the data written to a table linked to the
form. I can get data from the table to the form, but I
need to get this particular field back to the table.
It must be simple, and I am too close to the problem.
Any help is appreciated.

Thank you
 
Have you thought about using a query to do the calculation
instead of the form? If you did this, then you could use
the query just like you would have used the original
table. Does this make sense?

KellyJo
 
First KellyJo thank you for the fast response.
No I did not think about using a query (told you I was too
close to the problem).
What I need to do is to capture the result of the final
calculation, combine it with data in a table, and print a
report containing the data. As the calculated value
resides only in memory, and only when the calculation is
performed, I cannot capture this value unless the form is
displayed, and the data calculated. I will try a query,
and if you have any additional suggestions as always they
will be appreciated.
 
Back
Top