Contact US

Log In

Come Join Us!

Are you a
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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Control Source Help

Control Source Help

Control Source Help

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.

RE: Control Source Help

Try this instead.
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
 Ask me how Bar-codes can help you be more productive.

RE: Control Source Help

Do I understand that you want to put the result of a calculation into the table?  Generally, this is considered bad form, unless it is a calculation that cannot be reproduced in the future.  An example of this would be a Total value for an invoice.  This might be stored, since prices for items will change.

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.


RE: Control Source Help

Well, I do need to store the calculation to a table. This form is for Purchase Orders. So maybe when I close the form, the table can be update. The sum is coming from a subform that has all of the items, qyt, unit price and total price.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

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.

Join Us             Close