Dlookup: What am I doing wrong? 1

[mkrets]

I'm trying to set the value of a text field on the AfterUpdate event of a combo box with:

Me.txtCustName = DLookup("[CustName]", "tblCustomers", "[IntCustNum] = '" & [cboIntCustNum] & "'")

But I keep getting a data mismatch error.

Is there something wrong with the format of my Dlookup?

 

[jrbarnett]

My guess is that the intCustNum field is an integer, so the apostrophes aren't needed around it.

Me.txtCustName = DLookup("[CustName]", "tblCustomers", "[IntCustNum] = " & [cboIntCustNum])

John

 

[fneily]

Isn't it:
Me!txtCustName = DLookup("[CustName]", "tblCustomers", "[IntCustNum] = " & Forms![Formname]![cboIntCustNum]

Put your formname in.

 

[mkrets]

Thanks jbarnett, that was the problem.