troubleshooting Question

too few parameters , expected 3

Avatar of Sean HF
Sean HF asked on
Microsoft Access
15 Comments1 Solution141 ViewsLast Modified:
Hi, I get the below error msg when i try to run a macro, and idea how to sort this out? Thanks S.
err:
too few parameters , expected 3
program:
sub xxx()
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim stsq As String

Set db = CurrentDb
stsq = "SELECT [CRC].[Revenue] FROM [CRC] " & _
        "WHERE ((([CRC].[Project Number])="A") and (([CRC].[TaskNumber])="B") " & _
        "and (([CRC].[Account])="C") and (([CRC].[Revenue])<>0))"
Set rst = db.OpenRecordset(stsq, dbOpenDynaset)

rst.Edit
rst([Revenue]) = 999
rst.Update
end sub
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros