Error with Syntax in Form

[melb]

I have a form, it keeps giving me runtime error 3075



Syntax error missing operator in query express 'adressid='

Set rs = CurrentDb.OpenRecordset("SELECT count(*) FROM correspondence where addressid=" & Me.AddressID)

[ranman256]

You didn't ....hmmm,it looks right UNLESS addressId is null. Then it fails.

[Missinglinq]

Is addressID defined as a Number or as Text? Your syntax is only correct if it is defined as a Number...and all 'digit only' fields are not defined as Numbers, especially ID numbers, SSNs, Area Codes, Zip Codes, etc. Most developers only use Number Datatypes if the Field can or will be used for math.

Linq ;0)>