0

eing a beginning programmer I keep on getting the "Too few parameters. Expected 1." errormsg. I am trying to update the field "startmaand" with the value of Public declared variable "varAanvang_global" _ (this in a 1 row table)

Can anybody tell me what I am doing wrong here? I very much appreciate any help. Here is the code:

Public varAanvang_global 'this resides in the declaration part

Private Sub cmbAanvangsMaand_AfterUpdate()
Dim strUpdate As String
    If Not IsNull(Me.cmbAanvangsMaand) Then
        varAanvang_global = cmbAanvangsMaand
    End If
strUpdate = "Update [tblStartMonth] SET [startmaand] = varAanvang_global where ID = 1"
CurrentDb.Execute strUpdate, dbFailOnError
Debug.Print varAanvang_global
End Sub

Thanks in advance !

Ronny

Ronny Sigo
  • 1
  • 2
  • Global variables are not parameters. You can either use `DoCmd.RunSQL` and use the form field directly, or any of the other ways to use parameters as described in the duplicate. – Erik A Mar 22 '22 at 18:08

0 Answers0