SQL for a text box

[wizcow]

Hi

On my 'Invoice' form I have a text box displaying the 'CustomerID'.
Of course this gives me a number in the text box not a name.
I want to store the number (CustomerID), but I want to display the 'Customer Name'.

Is there some SQL or some other method of having the text box look up the customer number and then display the 'Customer Name' from the Customer Table?

Tom

 

[WayneRyan]

Tom,

Make your textbox that holds the number invisible.

Make a new textbox for the name.

When you get or move to a new record use the DLookUp
function to get the customers name. Then move this name
to your new textbox.

Wayne