Control Source Help
Control Source Help
(OP)
If I have the a Sum in the control source, how can I get that value to update the table. It seems that I can either have it bound to a field or do the calculation for me.
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: Control Source Help
Add a new text box.
Make its control source the field in the table
In the forms [bold]On_Current[/bold] event put a reference to the textbox with the formula
Like so:
Me![NewTextbox] = Me![TextboxWithformula]
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
RE: Control Source Help
Anyway, that's my first question: do you really need to store the calculation (if that's what you are asking?)
Second Question: You have a sum on your form. Where is the data coming from that is being summed? Is it being entered? If so, how do you know when all items to be summed have been entered? You don't want to write the sum to the table until it is complete.
Kathryn
RE: Control Source Help
thanks