Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calculations in forms
- Thread starter chark
- Start date
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]
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]
- Status
Similar threads
- Locked
- Question
- Locked
- Question
