Use Function in VBA

[Joakim N]

Hi,

I have used function DLookUp as ControlSource to a TextBox in a Form according to:



=DLookUp("[Company]";"[TCompany]";"[ID_Company]=1")

How can I write the same function but I want to store it to a variable in VBA? (In VBA Excel I use WorksheetFunction. to use a built in function) I don't know how to use a built in function in VBA Access.

Dim sCompany As String

'This line doesn't work. Of Course. But how can I write this code?
sCompany=DLookUp("[Company]";"[TCompany]";"[ID_Company]=1")

[Joakim N]

I found it myself. I just had to replace my ";" to ","

Dim sCompany As String
sCompany = DLookup("[Company]", "[TCompany]", "[ID_Company]=1")

[CJ_London]

just to clarify - regional settings can make a difference. You are using semi colons as parameter separators - they are usually commas