I m using access 2007. I want to use following update query in access vba but its giving error. Query is:
Docmd.RunSQL ("UPDATE property set property.status="& "'empty'" & " Where property.propertyid="& me.cmbpropertyid.value &"")
It gives the following error:
Missing ),], or item in query expression '(property.propertyid=4'.
Can anyone help me? Thnx......
Docmd.RunSQL ("UPDATE property set property.status="& "'empty'" & " Where property.propertyid="& me.cmbpropertyid.value &"")
It gives the following error:
Missing ),], or item in query expression '(property.propertyid=4'.
Can anyone help me? Thnx......