Calculations in forms
Calculations in forms
(OP)
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?
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
Computer / IT professional?
Join Tek-Tips Forums!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts - Keyword Search
- One-Click Access To Your
Favorite Forums - Automated Signatures
On Your Posts - Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Talk To Other Members
RE: Calculations in forms
much the same way!
add a textbox set it's control source (use the expresion builder,.. if you must
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
Robert Dwyer
rdwyer@orion-online.com.au