Using the expression bilder

[razzel]

Hi,

I have one question about expressions.

I have two tables and one form. The tables are not connected via relations.

• table1
• table2

In the form there is a text field and I want the textfield to fetch data from table2. The problem is that I do not know how to refer to a table in an expression.

If I write [table2] it will treat it as a field name, and produce an error since there is no field with the name "table2".

Any idea?

[amrut]

Try with Dlookup http://www.techonthenet.com/access/f...in/dlookup.php