Elookup with multiple criteria

[GS500]

I'm trying to use the following expression:

=IIf(ELookUp("EventDate","qsfrmEvents","[EventID] = 8 And [fkClaimID] = ' & [Forms].[frmClaim].[txtClaimID]'")>0,True,False)

But I'm getting a data type mismatch. txtClaimID is numeric, but if I take out the single quotes I get a syntax error.

Any ideas?

Thanks

 

[boblarson]

Should be:

=IIf(ELookUp("EventDate","qsfrmEvents","[EventID] = 8 And [fkClaimID] = " & [Forms].[frmClaim].[txtClaimID])>0,True,False)

 

[GS500]

Thanks, I see that in Allen's example now. I need to read more carefully.