Calculations in forms

[chark]

I have to teach a class in Access, which I do anyway, but this is more complicated. How do I create calculations in a form? Easy in a query, but in a form? [sig][/sig]

 

[Robertd]

Hi Chark,

much the same way!

add a textbox set it's control source (use the expresion builder,.. if you must ;-) ) same applies it has access to the data items available in the record set and other controls.

you may also need to use the .recalc method to dynamically update the results (avoid cicular references!)

then you have it, this is ok but queries are better as the record source has the calculations already done. (if you have a multi record subform you will see a lag between when the form is displayed to when the controls are updated!

as in queries the data source can also be a function, the same applies they are bound controls so you cant change/enter data into them.

HTH
[sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]