I have a form which has an unbound text box on it. The unbound textbox calculates a total from two others fields on the same form. I need to know how to save the value calculated by the unbound textbox into a field of the source table of the form.
Saving value from an unbound textbox
- Thread starter david444
- Start date
david,
You should not store calculated fields unless you have very good reasons for it. At the moment I can't think of one right now
.
You might get problems with data concistency.
However if you must......
Set your StoreField to the Calculated value, something like this:
Forms!YourFormNameHere!YourControlName=CalculatedControl
where ControlName is a field on the form which should store the value in the underlying table.
The best thing to do would do the calculation when you need it.
hth
Gerhard
You should not store calculated fields unless you have very good reasons for it. At the moment I can't think of one right now
.You might get problems with data concistency.
However if you must......
Set your StoreField to the Calculated value, something like this:
Forms!YourFormNameHere!YourControlName=CalculatedControl
where ControlName is a field on the form which should store the value in the underlying table.
The best thing to do would do the calculation when you need it.
hth
Gerhard
