Unanswered: How to delete the value stored in a Field of a Row?
How do I delete a value from a field? I have a form with its record source set to a table (tbl1) and I want to move to a record e.g. record number 5, and then click a command button and delete field3's value so it is empty for that record.
I have tried this in my command button, but it deletes the whole record, not just the value stored in field3 -
DoCmd****nSQL "DELETE tbl1.field3 FROM tbl1 WHERE (((tbl1.mainID)=[Forms]![main_frm]![mainID]) AND ((tbl3.field3)=[Forms]![main_frm]![