sql errors out when field is blank

[swmorin]

I have my sql field in ## marks for an update query written in VBA.

",tbl_instructor_dates.isdcw = #" & [Forms]![frm_instructor_misc_info_update]![ISDcw] & "# " & _

It works fine as long as the field is not blank. Unfortunately if the field is blank it equals null and gives me an error becauseof the #.

How do I avoid this

 

[pbaldy]

Do you want to not run the query if it's blank, or let it run with some sort of default value?

 

[swmorin]

i want to let it run

 

[pbaldy]

With a default date, or setting the field to Null? Personally I might build the SQL without that field, but this should work for a default.

"...isdcw = #" & Nz([Forms]![frm_instructor_misc_info_update]![ISDcw], 1/1/2012) & "# "...

Might need quotes around the date.