Need help displaying a record in a form...

[KENTOY]

These are the table i have:

Customer - fields (Id, CustName,... RepName)
SaleRep - field (Id, RepName)
Orders - field (Id, CustName, OrderNo, OrderDate)

I have a Orders Form (control source Orders table) containing a combo box for customer name, when the user selects a particular customer, i want a text box to automatically display the linked Sales Representative (found in Customer table)...

Anybody can help me...

Thanks
kent0y@yahoo.com

 

[jbehrne]

Hi,

A simple Dlookup statement should do the trick:

Me!SalesRep = DLookup("[RepName]", "Customer", "[ID] = [ComboBox]&quot

HTH,

jbehrne If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations