CurrentDb.Execute

E

Ed Carron

When I run a CurrentDb.Execute statement with a stored Access Insert Query
as the first argument, and dbFailOnError as the second argument, I get an
error message "Too few parameters. Expected 3."

When I rewrite the statement to have a hard-coded insert statement as the
first argument, and dbFailOnError as the second argument, the code works
fine.

Problem is I need to run the execute with the stored Access Insert Query
that gets its insert values from controls on the active form.

Is there a way that I can do that?

Thanks,

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top