Object Doesn't support this Property or method

[DrSmyth]

Hi,

I'm trying to get a dlookup to work on an access 97 form. The filed i'm looking for is called "AFSM Code" and it's in table "qlinks1", the field i'm using for the lookup in the form is called "Referral to name" and it's corresponding field in the table is "FPM/FPO Code".

Here's my code:

Me.AFSM = DLookup("[AFSM Code]", "qlinks1", "[FPM/FPO Code]= '" & Me.Referral_To_Name & "'")

However i'm getting a Run time 438 error. The only thing i can think of is that the field i'm looking up in the table is a text field that stores a number and/or this field ("FPM/FPO Code") is also used as the bound column in "Referral to name".

Hope this makes sense, can anybody help?

Thanks

 

[PHV]

Perhaps this ?
Me!AFSM = DLookup("[AFSM Code]", "qlinks1", "[FPM/FPO Code]= '" & Me![Referral To Name] & "'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DrSmyth]

Cheers PHV, still getting the same error message

 

[DrSmyth]

Have changed it a little to try and figure out where the code braeks down:

Dim str1 As String
str1 = CStr([Referral_To_Name])
MsgBox (DLookup("[AFSM Code]", "qLinks1", "[FPM/FPO Code]= '" & str1 & "'"))

And it actually breakes down on the line:

str1 = CStr([Referral_To_Name])

with the error message above

 

[PHV]

Use the expression builder (loaded forms) to discover the REAL name of the control.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886