Updating/calculating a field on a form when you save and then disp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has total amd avg fields. They are loaded from a table and
then shown on the form. I need to up date the records and then save it and
show the updates on the form before I send it to to be emailed. How do you do
that in a macro?? I have two buttons: save and email. Many Many Thanks for
you help ..
 
tkirchoff15,

Saving an edited record can be done in a macro using tghe
RunCommand/SaveRecord action.

Emailing can be done using a SendObject action. The 'object' that is
sent would normally be a query, or a report based on a query. Since you
have total and average values, these are calculated values. I assume
these are being calculated on the form. If so, forget the form from the
point of view of your email. Re-calculate these values in the query, or
report.
 
Back
Top