As June7 mentioned in Post #2, here's the code. Modify your clear button code to this:
If it works for MA, you can replicate for the other areas.
Code:
Option Compare Database
Option Explicit
Private Sub Command20_Click()
Dim sSQL As String
sSQL = "Update [MA Assignments] SET " _
& "[Monday Dispatcher] ='" & vbNullString & "', " _
& "[Tuesday Dispatcher] ='" & vbNullString & "', " _
& "[Wednesday Dispatcher] ='" & vbNullString & "', " _
& "[Thursday Dispatcher] ='" & vbNullString & "', " _
& "[Friday Dispatcher] ='" & vbNullString & "', " _
& "[Saturday Dispatcher] ='" & vbNullString & "', " _
& "[Sunday Dispatcher] ='" & vbNullString & "'"
Debug.Print sSQL
CurrentDb.Execute sSQL, dbFailOnError
Me.Requery
' Me.Monday_Dispatcher = Null
' Me.Tuesday_Dispatcher = Null
' Me.Wednesday_Dispatcher = Null
' Me.Thursday_Dispatcher = Null
' Me.Friday_Dispatcher = Null
' Me.Saturday_Dispatcher = Null
' Me.Sunday_Dispatcher = Null
End Sub