Syntax Error

[seth1685]

Hello, I can't work out why:



If (IsNull(DLookup("[Module]", "Table1", "[Module]=" & Me.Combo23)))

Is generating a syntax error when the code I based it on:

If (IsNull(DLookup("[External Examiner]", "Together", "[External Examiner]=" & Forms![Copy of Add EE Assignment]!Combo21)))

Isn't.

Any ideas? Thanks.

[jzwp11]

What is the datatype of the Module field in table1?

[seth1685]

Text. Think I've got it now.

Thanks!

[jzwp11]

Can you post your solution for the benefit of others who may come across this thread while looking for a solution to a similar question?