check box-if true use field in different table

[Guest]

the below code is attached to a check box on my form.
Instead of me.T1I1 = 9
Is it possible to ... me.T1I1= table.field where TopicID = 1

I want it to use a field that is in a different table than what I am using
on th form.

Private Sub T1I1ck_Click()
If Me.T1I1ck = True Then
Me.T1I1 = 9
Else
Me.T1I1 = 0
End If
End Sub

 

[Guest]

hhhh

 

[Guest]

I don't understand your reply.

I need help with this. It is important to me.
Please someone help.

 

[Guest]

You can grab the value from a field in another table using DLookup()

Me.Tili= DLookup("SomeField","SomeTable","AnotherNumericField =" & Me.txtA )