CurrentDb.Execute returning 'Too few parameters' error.

[WeeZaliban]

I have been building a Sub in a standalone database and have run into an issue with running a query native to the same database.

I have in the same sub as part of an If function, another CurrentDb.Execute and it works fine; however, when it gets to the next part of the Sub, the secondary CurrentDb.Execute, I get the 'too few parameters error'.

Both Update Queries are built in SQL in Access 2007 and function properly when executed.

Here's a sample of the code I have:

If insertstuffhere Then
CurrentDb.Execute ("First Update Query That Works"), dbFailOnError
Else
Me.StatusLabel.Caption = "Witty text"
End If

If insertstuffhere_part2 Then
CurrentDb.Execute ("Second Update Query That Doesn't Work"), dbFailOnError
Else
Me.StatusLabel.Caption = "More witty text"
End If

Any help is greatly appreciated!

Thanks,

WeeZ

 

[WeeZaliban]

Please disregard. I mislabeled a field in the second update query.