cmdButton to clear contents of a column

[Neil_Pattison]

Is there a way i can use a command button on a form to clear the contents of a yes/no column in a table.

I can do this via an update query but I would prefer it if I could do it without getting any propmts warning of the update.

Any help would be greatly appreciated

 

[tehNellie]

Wrap your update command in:

Docmd.setwarnings false
  docmd.runsql strSQL
docmd.setwarnings true

This will prevent the warnings from being shown for that query.

 

[Neil_Pattison]

Thanks a lot