DLookup not working properly 1

[NFI]

Hello,

Having been told about DCount, I saw that I needed to use DLookup for one of my Control Source fields.

The code I'm using is this;

=DLookUp("[STR]","Job_M","[Title] = " & [ComboJob].[Value])

but it just returns #Error

All the field names are correct and I know ComboJob.Value returns the correct value, so why isn't this working?

Any thoughts would be much appreciated,

Thanks,

Paul

 

[longhair]

NFI,
STR is the name of the field and Job_M is the name of the table?
regards,
longhair

 

[PHV]

If Title is defined as string in the Job_M table:

=DLookUp("STR","Job_M","Title='" & [ComboJob] & "'")

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

 

[NFI]

Thanks for your help, chaps.

That was the problem, I needed to enclose ComboJob.Value in single quotes...

Many thanks,

Paul