Lookup and display a value from a table based on value in other cell?

[Rich_B]

Hi

I have a textbox that I wish to auto populate with data based on the value entered into an adjacent box.

QUOTE_REF_1 is a four digit integer say "1287".

When 1287 is entered into the QUOTE_REF_1 control I want Access to search my table tblCLIENT_DETAILS and find the 1287 row and return the value from the CLIENT_NAME field on that row and display it in the textbox control CLIENT_NAME on my form.

I'm sure this can be done but I'm struggling.

Any guidance appreciated.

Thank you