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?
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
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