Control Source Help 1

[webjunk]

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.

 

[DougP]

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
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[kathryn]

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.




Kathryn

 

[webjunk]

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.

thanks