The argument is not Optional,Acces VBA

[aziz145p]

Hello, im still beginner in the world of acces and VBA, I was making buttons that could change some details in the database However, after writing the code im getting this message: The argument is not Optional.
--------------------------------------------------------------------------------

Private Sub cmdajout_Click()
Dim t As String, code As String, rep As String
Dim req As String
rep = MsgBox("Vous vouler Modifier Un client Telephone", vbYesNo + vbQuestion + vbDefaultButton2, "information")
If rep = vbNo Then
MsgBox "Operation Annulée"
Else
code = InputBox("Entre le client Code")
t = InputBox("Entre un Nouvaux numero")
req = "update Client set Tel='" & t & "' where Cdclt='" & code & "'"
DoCmd.RunSQL
MsgBox "mise Ajour terminer Avec Succes"
End If
End Sub

------------------------------------------------------------------------
A professional will easily see what I'm doing wrong, so please as I said I'm still beginner, thanks

[Seth Schrock]

Please use CODE tags when posting code, per the site's rules.

I believe the error is in your DoCmd.RunSQL line as you don't provide the SQL that needs to be ran. Your code should be

DoCmd.RunSQL req

You might also get an error because of declaring rep as a string. It should be declared as an Integer. Even if you don't get an error on this, you really should change it.

[aziz145p]

Many thanks,man and sorry about the CODE thing,this was my first question many thanks.