Bill and John,
Thank you! I don't know what got into me. I must have gotten bit by the bug parentheitis. Your responses helped me to understand the use of quotes etc. Hopefully it will stick in my brain ;-)
Connie
--- 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