Surely This Is Simple?

[Dannybe2]

I'm trying to fill in a field from another field in a form in Microsoft Access, and it won't let me.

I'm using the following code:

Me.CompanyTelephoneNumber = DLookUp("CompanyTelephoneNumber", "Company Book", "Company = " & Me.Company.Value"

I get an error with the criteria which doesn't appear to be right. The helpful tooltip tells me the correct me.company.value as does the immediate window. Shouldn't it be "CompanyID = " & Me.Company.Value" ?

 

[ETID]

The table name might have to be in brackets [table_name] to distinguish it from fields "field_name".

 

[JoaoTL]

Me.CompanyTelephoneNumber = DLookUp("[CompanyTelephoneNumber]", "Company Book", "[Company] = Company&quot

*Company* should be your Control Name

You can´t use the Me Keyword in Dlookup() Function...Only when you have the Recordset Open like in .FindFirst
Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt