Passing data from one form to another (1 Viewer)

[Hunter]

I have a form in which the footer contains a text which displays the sum of a number of fields in the detail section. I am having trouble passing this value to another form. Any ideas?

Thanks

 

[Jack Cowley]

Create a global variable. Set the data in your text field to that variable name. In the next form you can use the On Open event, or other event, to set the Text box in that form to the Global variable.

In a Module put something like this: Public GlobalVar As String.

In the button that opens the new form put something like this: GlobalVar = Me![TextYouWantToPass]

In the On Open event of the new form put: Me[TextBoxName] = GlobalVar

HTH,
Jack