Hello,
I have a unbound text box on a form. This gives a total from a calculation. I would like this total from the unbound text box to appear on another form.
I just need the total on the other form, not the calculation.
How do i do this?
As it is technically a field on a form, you can just do:
[Forms]![theFormThisTextBoxAppearsOn]![theNameOfTheTextBox].value
The .value is optional, but watch out for nulls or if the form isn't open. (It might be worth passing it as a parameter or setting a global variable instead when the second form is opened). Ie. Public x as Integer on the second form, and from the first, [Forms]![form2].x = me.txtWhatever.value
Hope this helps.