Question Expression Builder

[pckong]

Hello,

I am relatively new to MS access. My question is about expression builder and it is problably pretty simple, but I won't figure out how.

I added a Text Box and use Control Source to choose a data source from another table. And I used Expression Builder. The field in Expression Builder is as following: " =[DataTable]![Column1] " (I need item1 in Column1 in the DataTable)
But I kept having the Enter Parameter Value pop-up and got #Error.

How do I build the Expression Builder properly ?

Thanks
PJ

 

[DavidAtWork]

Have you considered using the form/report control source to include this data. If the form/report is running off a query then edit your query to add an new table and field, if it's running off a table then change the source to a query.
If you have to use it the way you describe, then you probably need to use DLookup function

David

 

[pckong]

Hi David

Thank you for the reply. I got the cross-table data look up working, by using DLookup function as you have mentioned.

It is frustrated that the expression builder supposed to do the right thing, but it dones't work.

Thanks again.
PJ

 

[Mihail]

I have had a subscription to this thread, hoping to, finally, understand how to use this "Expression Builder" in order to catch some data from a table/query and to use it into an unbound form.
Unfortunately, seems that no one have an answer. But I still expect