Calculated column with look up info (1 Viewer)

My problem seems simple, but after hours searching and trying, I gave up.
I have 2 tables:
Table1: ID(auto), Name(text)
Table2: ID(auto), T1ID(number), T1Name(text)
I just want to enter a number ID in 'T1ID' and get the corresponding 'Name' from Table1 in field T1Name.
I've tried using a calculated column DLookUp("[Name]","Table1","[ID] = " & [T1ID]), but Access doesn't accept it.

You shouldn't store the name. More here:

http://baldyweb.com/Autofill.htm