You're welcome, Connie. I've noticed a few places where you added parens that aren't necessary, but better over-kill than ommission.
Bill
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> 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