Thanks Ofer,

Both the flgFieldNo and the txtFlgField are text that are input by the user.
I am doing it this way because I have 9 flag fields and I don't want to have
to program a button for each flag field.

I tried to update the code but am failing miserably.  Still getting the
syntax error in UPDATE Statement message.

Here is my updated code:

Private Sub btn_ClFlag_Click()
On Error GoTo Err_btn_ClFlag_Click

   Dim strSQL As String
   Dim flgFieldNo As String
   Dim txtFlgfield As String
   
   flgFieldNo = InputBox("Enter Flag #:", "Flag Field")
   txtFlgfield = InputBox("Enter Flag Criteria to be Cleared.  i.e.",
"Clear Flag" & flgFieldNo)
       
   If Me.Dirty Then
       Me.Dirty = False
   End If
     
   strSQL = "UPDATE Tbl_Contacts SET Tbl_Contacts.Flag'" & flgFieldNo & "
="" WHERE ((Tbl_Contacts.Flag'" & flgFieldNo & "'" & ") = '" & txtFlgfield &
"'" & ");"
   
   DBEngine(0)(0).Execute strSQL, dbFailOnError
   
   Me.Requery

Exit_btn_ClFlag_Click:
   Exit Sub

Err_btn_ClFlag_Click:
   msgbox Err.Description
   Resume Exit_btn_ClFlag_Click
   
End Sub

Can you please help.