applying dynamic queries to text boxes

[gambithunt]

Please can someone help me to get a text box to display a specific table field based on another textboxes value which comes from a different table.

I have a relational database one with say purchases and one with client info, when an item is purchased the client ID is linked to that purchase, I would like to get the client name from the client database and display it in a textbox on the same form in relation to that client number,

You held is much appreciated

G

 

[rainman89]

use a Dlookup

 

[gambithunt]

use a Dlookup

thanks very much, but how do I use, I'm mean where do I insert the code, in the button and how do I get it to relate to the list?

 

[rainman89]

you put the code as the control source of the other text box on your form, and u would use something along the lines of

=dlookup([Clientname],[clienttablename],"[client ID]=" & Forms!yourFormName!ClientIDControlName)<--me.clientID might even work

 

[gambithunt]

thanks very much