DLookup driving me mad

[KieranJ2020]

Hi All,


New user so apologies in advance if i have posted this in the wrong place, but I cannot for the life of me understand why this dlookup is returning a "Compile Error Expected: ="

The dlookup is

dlookup("ChecksCompleted","dbo_tblCurrentStrategy" , "EngineerName =: '" & me.cboOpCompleting.Value & "'")

dbo_tblCurrentStrategy is a linked table which resides on an SQL Server and me.cboOpCompleting.Value is a combo box which has a list of names. The dlookup is sitting in the vba of the form itself.

I have tried many iterations and it is slowly driving me to the point of insanity.

Thank you in advance for any help!

Kieran

[CJ_London]

would have thought the error message was clear enough

"EngineerName =: '"

should be

"EngineerName = '"

or if you are trying to exclude the value

"EngineerName <> '"

[KieranJ2020]

Thank you for taking the time to reply to me! I've changed the criteria to what you suggested and i am still getting the same error message

[Micron]

I have a different notion of the error: because there is nothing on the left side for it to be equal to; i.e.
something = dlookup("ChecksCompleted","dbo_tblCurrentStrategy" , "EngineerName = '" & me.cboOpCompleting.Value & "'")

The colon should not be there, but if it is, it does not generate a compile error for me but it does raise a syntax error at run time. However not passing the return value of the DLookup function to something does generate a compile error.

[Welshgasman]

Hi All,
New user so apologies in advance if i have posted this in the wrong place, but I cannot for the life of me understand why this dlookup is returning a "Compile Error Expected: ="

The dlookup is

dlookup("ChecksCompleted","dbo_tblCurrentStrategy" , "EngineerName =: '" & me.cboOpCompleting.Value & "'")

dbo_tblCurrentStrategy is a linked table which resides on an SQL Server and me.cboOpCompleting.Value is a combo box which has a list of names. The dlookup is sitting in the vba of the form itself.

I have tried many iterations and it is slowly driving me to the point of insanity.

Thank you in advance for any help!

Kieran

You appear to be confusing keyword parameters with the actual contents of a parameter?

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.

[Welshgasman]

Thank you for taking the time to reply to me! I've changed the criteria to what you suggested and i am still getting the same error message

Perhaps show all the code you are using?
As mentioned something has to be assigned the result of the dlookup?

When in doubt, look up the syntax.
https://support.microsoft.com/en-us/...b-bed10dca5937

[pbaldy]

I should have mentioned the moderated post had a failed attachment. This may help:

https://www.accessforums.net/showthread.php?t=70301