Error using DLookup to retrieve from another form

[ktimov1]

I have two forms (form1, form2). Form1 has a combo box named "Owner" which lists locations. I want a textbox in form2 to update with whichever location the user chooses from form1.

Im using the DLookup function:
=DLookup("[location]", "tblAddress", "[location] =" & Forms![form1]!Owner)

Any ideas on why I get an error?

 

[DCrake]

It may help if you tell us what type of error you are getting.

 

[ktimov1]

All the textbox shows is #Error

 

[DCrake]

Is the form that has the control open? It must be open to get the data.

 

[ktimov1]

Oh jeez, I didn't think about that... I guess it's too early for me to be messing around with databases.

Thanks a lot!