Ms access form calculation updating table
An awful lot of processing to do in order to avoid storing a calculated value, especially considering the cheap memory that's available today.You haven't said how you're doing these calculations, but I'm guessing that you're using them in the Properties sheet as the Control Source for the textboxes, which is why they're not being stored. Linq ;0) Never is something that probably should You haven't said how you're doing these calculations, but I'm guessing that you're using them in the Properties sheet as the Control Source for the textboxes, which is why they're not being stored. Linq ;0) Hi, Thanks, that is exactly what I was doing, putting the formula into the control source. Type = wd Normal View End If End Sub This macro is rather clever, in that all it does is switch from whatever view you are in (Draft/Normal or Print Layout view) to the other view, and then back again.
Hi, I have a form which updates my table just fine except for some fields in the form are expressions, and the results of the expressions do not populate the table, but the form always remembers the results of the expression.Hope that helps, If you have more questions, please feel free to post again. Yeah, that's what I keep reading all over when I research this problem, but if I want to store calculated values in a table, that's really my call to make, not Microsofts. What I am trying to enter is just the price paid for a group of items, then divided by the number of the items, so the calculated value is the price per item.After it's calculated those figures will never change.Word allows you to create special forms that rely on fields for the gathering of information. He is president of Sharon Parq Associates, a computer and publishing services company. These forms can be protected so that text outside of the form fields cannot be modified by users.