textbox calculations extended

[PatriciaShoe]

I have a textbox in a form that is derived by the use of a function that I created. This is working just fine. I now have the need to take this value and apply some additional logic to the value to determine a new value for another form textbox. The question - what is the best way to refer to this value in the new form text box? Do I have to repeat the control source from the first text box to perform the calculations in the new textbox? I will most likely use a case statement to test for new values. Thanks,

Patti

 

[MajP]

You could theoretically reference the first control, but you could get in trouble this way because it is possible the second function references the first control that has not yet been updated. I would simply build control 1's recordsource with a custom function even if you simply can write this in the recordsource of the control. Then build control 2 with a custom function that calls control 1's custom function.