SQL Insert Into Fails

[Randy]

The following SQL event will not update the CustomerData table if the FrmContact field on the form is left blank. I have this code in the OnLostFocus Event. Is it possible to have this command update the fields that do have data entered in them even though the FrmContact field is blank?



DoCmd.RunSQL "INSERT INTO CustomerData (CustomerName, CustomerAddress, CustomerCityStateZip, CustomerPhone, CustomerContact, LockRecs) " & " VALUES (""" & Forms!frmflcdeliver.Controls!FrmCompany & """ , """ & Forms!frmflcdeliver.Controls!FrmAddress & """, """ & Forms!frmflcdeliver.Controls!FrmCityStateZip & """, """ & Forms!frmflcdeliver.Controls!FrmPhone & """, """ & Forms!frmflcdeliver.Controls!FrmContact & """, """ & Forms!frmflcdeliver.Controls!FrmLocked & """)"

[June7]

Don't need the .Controls qualifier, although probably not an issue.

I think problem is the value is delimited as text so Null causes error. Use IIf to handle possible Null.

Is this code behind frmflcdeliver? If so, can use Me alias. I prefer apostrophe instead of two quote marks for text delimiter.

& IIf(IsNull(Me.FrmContact), Null, "'" & Me.FrmContact & "'") &

[Randy]

Thank you Jun7: I haven't tried it yet but I will reply back with the outcome.