Runtime Error 13 Type Mismatch

[berg]

Hi,

I am pretty new to VBA and am trying to do a lookup. I am getting a Runtime Error 13 Type Mismatch for the following line of code:

Me.sf_LabelView!txtLabel.value = DLookup("[Label]", "[tbl_LabelsUsed]", "[Individual_Id] = '" & IndividualId & "'" And "[Use_Id] = 1" And "[Type] = 1")

Am I missing anything obvious here?

Thanks!

 

[jdraw]

What data type is Individual_Id? If numeric, you might try this (untested)

Me.sf_LabelView!txtLabel.value = DLookup("[Label]", "[tbl_LabelsUsed]", "[Individual_Id] = " & IndividualId & " And [Use_Id] = 1 And [Type] = 1")

 

[berg]

Thanks jdraw,

I have it written as you described, but am now getting an error for expected list separator or ). Any thoughts?

 

[jdraw]

Can you post all the code for the event?