DLookup (1 Viewer)

[BadScript]

I'm trying to populate a textbox using DLookup.
My textbox is called text1.
I have a table called Table Language.
I'm trying to get the value from the column text1 where IDlanguage = 1
The code I use:

text1.Value = DLookup("[text1]", "Table Language", "[IDlanguage] = 1")

I keep getting an error and can't figure out why.
Help would be appreciated.

 

[Zigzag]

What error message are you getting?

 

[BadScript]

What error message are you getting?

I figured it out, I tried:
text1 = DLookup("[text1]", "Table Language", "[IDlanguage] = 1")

And it worked