DlookUp problem 1

[Binnit]

The following is triggered by an afterupdate event on
Me.txtWIDNo

I am getting a Data type mismatch error when this runs and I'm not sure why.

Dim ReturnedDate As Date

ReturnedDate = DLookup("[WIDreturneddate]", "[tblwids]", "[WIDno1] = '" & Me.txtWIDNo & "'")

[WIDreturneddate] is a date field
[WIDno1] is a Long int number field
Me.txtWIDNo is a text box on my form

Any pointers where I'm going wrong?

Happiness is...not getting what you want but wanting what you have already got

 

[orna]

Dim ReturnedDate As Date

ReturnedDate = DLookup("[WIDreturneddate]", "[tblwids]", "[WIDno1] = " & Me.txtWIDNo )

 

[Binnit]

orna
Thanks a bundle thats cleared it up, simple when you know how!



Happiness is...not getting what you want but wanting what you have already got