Clear values in a table column

[kenicho2]

All I want is a button that will clear all data in a specific column of a table. I created my form, added a button, and entered the following SQL statment...

Sub Command3_Click()

Update RecipeList
Set DayID = Null

End Sub

When I run it, I get "Compile error: Sub or Function not defined". I can run other sql statements, such as to display a message box. It just does not seem to recognize the "Update" statement. What am I doing wrong? Thanks for helping this amateur!

 

[xenou]

Your SQL statement is correct but to run it you need a slightly different syntax:

Sub Foo()

DoCmd.RunSQL ("Update RecipeList Set DayID = Null;")

End Sub

If you want the command to execute "silently" then:

Sub Foo()

DoCmd.SetWarnings False
DoCmd.RunSQL ("Update RecipeList Set DayID = Null;")
DoCmd.SetWarnings True
 
End Sub

ξ

 

[kenicho2]

Excellent. Thanks for your help.