DLookup Help anyone ?

[traversd]

Hi,

I have a form called Opportunity_Table1, that has a Combo Box called Contact Name, which gives a list of customer in the table "Customer_Table"

I want to automatically display the company name, depending on which Contact is selected in "Contact name" in the txt field "Company"

Does anyone know of the syntax I need to use ? I have been wrestling with DLookup to keep getting an #Error? Message !

Thanks
Darren

 

[Russell Hauf]

A bit more information is needed. Are Contact and Company Name in the same table?

The basic way to do this is to put code in the AfterUpdate event of the ComboBox. So something like:

Private Sub Contact_Name_AfterUpdate()
    Me.txtCompany = DLOOKUP("[Company Name]","Customer_Table" _
        ,"[Contact Name] = '" & Me.Contact_Name.Value & "'"
End Sub

But if the Contact Name (or customer - you've confused me a little here) and Company Name are not in the same table, then you'll need to refer to a query instead of "Customer_Table".

Hope this helps,

Russell