Pull up info in form using an ID

[jcmeyer5]

I have a table of customers. Each customer has an ID and details. I want to be able to call up a customer's details by entering their ID. I do NOT want this information to be editable... I jsut want it there so I can say "you are john Doe from 123 main street?"

I have 2 tables I am working with... transactions (TransID*, CustID Description, Amount) and Customers (CustID*, varioius details). When I go to select fields for my form, do I use the CustID from transactions or from Customer Table?

I know its a simple thing... I jsut forget how.

 

[shay]

Hi

You could include the customers name and details with the ID in a combo box. After a selection is made set

me.txtCustomer = "You are " & me.cmbCustomer(1) & " from " me.cmbCustomer(2) & "."

In this example, the customer name is in column 2 of the combo box and the address is in column 3.

This way users have no opportunity to change the customer information.

hth

shay

 

[jcmeyer5]

Hehe... oops.

I dont want that to display... I just want the information there so I can ask the customer. For instance, if I put in ID 9999, I want John Doe, 1234 Main St to pop up.

 

[shay]

That's fine - you don't have to display the extra info in the combo box. Just make the width of the additional columns zero. Then all the user will see is the customer ID but the customer name and address will be there available for you to use.

shay