Use form values in another form

[ajudante]

I have two forms. form1 has textbox1 and textbox2 asking user input. It also has a button that the user clicks after filling the boxes. The button closes form1 and opens form2. form2 has textbox3 with has a simple formula adding the values inserted by the use in textbox1 and textbox2. This needs to work even after form1 is closed. How to do this? I gather that there are two possible solutions, but I can't make them work.



Solution 1 is with Global Variables, with code below.

In a VBA Module:

Option Compare Database
Global Var1 As Single
Global Var2 As Single

In form1 button:

Private Sub Continue_button_Click()
Var1 = Val(Me.textbox1 & "")
Var2 = Val(Me.textbox2 & "")
DoCmd.OpenForm "form2"
DoCmd.Close acForm, Me.Name
End Sub

In form2 textbox3:
=[Var1]+[Var2]

In form2 textbox3 I get the #Name? error


Solution 2 is OpenArgs, with code below

In the form1 button

Private Sub Continue_button_Click()
docmd.openform "form2",,,,,textbox1 & ":" & textbox2
doCmd.Close acForm, Me.Name
End Sub

In the form2 load event

Var1=split(openargs,":")(0)
Var2=split(openargs,":")(1)

and in form2 textbox3
=[Var1]+[Var2]

This gives me a Run-time error 13 Type mismatch error

In both solutions, there is something line of code that is wrong or some code missing, but I can't figure out what. Any clues?

[davegri]

Try it without the brackets around var1 and var2.

[pbaldy]

You can't reference a VBA variable from a textbox control source, only from VBA. Your first method could place the values in the textbox in code in the load event:

me.textbox3 = Var1 + Var2

[kd2017]

FYI for solution #2 I would think it would be more like

Dim argArray() as Variant
argArray = Split(Me.OpenArgs, ":")
Me.Textbox3 = argArray(0) + argArray(1)

Also openargs is a string type so you may or may not have to do some type conversions....?

[ajudante]

Thanks. But var1 and var 2 are automatically added brackets

[ajudante]

Thanks. Where do I write that? In form1 button code or in form2 load code?

[ajudante]

You can't reference a VBA variable from a textbox control source, only from VBA. Your first method could place the values in the textbox in code in the load event:

me.textbox3 = Var1 + Var2

Thanks. I tried that and I got the same #Name? error

[pbaldy]

Thanks. I tried that and I got the same #Name? error

What I posted was VBA that would go in the form's load event. You'd first have to remove the existing formula.

[Micron]

cross posted with many answers
https://www.access-programmers.co.uk....310399/page-2

adjudante please read https://www.excelguru.ca/content.php?184

[CJ_London]

debug.print split("ABC:DEF",":")(0)

will return ABC