Calculating Percentage in a form

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

Guest

I have a subform that needs to calculate the percentage a certain value is
out of the whole. I also need to store the calculated percentage in a table.
How do I create an equation to calculate the percentage while using the
control source field to reference to the table I wanted to store the
calculate percentage in?
 
Ignoring the basic rule of not storing calculated values in a table, you just
need to find the best event in your code to update the value of the bound
control. The first place to consider would be the Before Update event of the
form:
 
Back
Top