SOLVED
Hello, I need to use field (TA113) when the form is loaded. The value of this field needs to be assigned from another field (A1TO13) from another form(frmS3A113).
I have my code below:
Private Sub Form_Load()
Dim x As Integer
x = Forms!MainS3!frmS3A113!A1TO13.Value
Me.TA113.Value = x
End Sub
However, when I open the form, the value of TA113 equals 0.
In the immediate table, when I check A1TO13's value, it shows 12.
? Forms!MainS3!frmS3A113!A1TO13.value
12
but if I check TA113, it shows 0.
?Forms!MainS3!frmS3A1425!TA113.value
0
Could you tell me what's wrong?
Thanks
Hello, I need to use field (TA113) when the form is loaded. The value of this field needs to be assigned from another field (A1TO13) from another form(frmS3A113).
I have my code below:
Private Sub Form_Load()
Dim x As Integer
x = Forms!MainS3!frmS3A113!A1TO13.Value
Me.TA113.Value = x
End Sub
However, when I open the form, the value of TA113 equals 0.
In the immediate table, when I check A1TO13's value, it shows 12.
? Forms!MainS3!frmS3A113!A1TO13.value
12
but if I check TA113, it shows 0.
?Forms!MainS3!frmS3A1425!TA113.value
0
Could you tell me what's wrong?
Thanks
Last edited: