Problem with Update SQL string and Null values

[Syerston]

I'm having a bit of trouble with an Update SQL string being passed to a MS Access table via a Command object. The problem arises if the date field or number field currently contains a value, and I try to delete the value from the form and then run the update string.

I have tried setting the variable values to Null and "" but to no avail.

Has anyone experienced this before?

PS. It works fine with the text fields.

 

[swampBoogie]

Show your code.