Connie
You are mixing your strings in the criteria parameter It should end up reading like one complete string.
IsNull(DLookup("ParcelNbr", "HomeInfo", _
"ParcelNbr = '" & Me.ParcelNbr & "' And CountyID = " _
& Me.CountyID))
The structure should be:
DLookup("FieldName","tableName","criteria")
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar