assign a value from another form

moyi

Registered User.
Local time
Today, 03:47
Joined
Oct 31, 2017
Messages
15
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
 
Last edited:
Thanks. I got it.
 

Users who are viewing this thread

Back
Top Bottom