DLOOKUP problem

[tintin007]

My database have a table &quot;tbl_Taxes&quot; that is compose of three field &quot;ID&quot;, &quot;TAX1&quot;, &quot;TAX2&quot;.<br><br>I'm in a form and I want to get the value of the field &quot;TAX1&quot; of the table &quot;tbl_Taxes&quot; where the &quot;ID&quot; is equal to &quot;1&quot;<br><br>I've tried the following line in the recordsource property of a text box but it didn't work<br><br>=DLookUp([tbl_Taxes]![TAX1],[tbl_Taxes],[tbl_Taxes]![ID]=&quot;1&quot<br><br>What is the problem

 

[samara]

try this...<br><br>=DLookUp(&quot;[TAX1]&quot;,&quot;tbl_Taxes&quot;,&quot;[ID]=1&quot<br><br>Hope this would help YOU...<br> <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>