ACCESS FEED: [MS_AccessPros] Type mismatch that I can't figure out

Rabu, 12 Oktober 2011

[MS_AccessPros] Type mismatch that I can't figure out

Good morning/whatever it is where you are!

I'm getting Type mismatch error.

The code:
-HomeInfo form
-ParcelNbr textbox
-AfterUpdate event
-Goal of the code is to check to see if there's another entry in the HomeInfo table with the same County and ParcelNbr and if so give a message saying that this property is already in the database.

ParcelNbr is text field
ContactID is a long integer in both the HomeInfo table and the County_List table.

When I hover Me.ParcelNbr = "12-0045-000" and Me.CountyID.Column(0) = "1" If I change it to Me.CountyID then when I hover Me.CountyID = 1. Either way I get the message.

Many thanks!
Connie

'If ParcelNbr in the same County exists in the HomeInfo table
If Not IsNull(DLookup("ParcelNbr", "HomeInfo", ("ParcelNbr = """ & Me.ParcelNbr & """") And ("CountyID = " & Me.CountyID.Column(0)))) Then
MsgBox "This Parcel Nbr is already in the database." & vbNewLine & _
"Use Ctrl F to find the property."
Me.Undo
DoCmd.GoToControl "ParcelNbr"
End If