To few parameters

Topic

New Reply

Good morning,

I am having problems with a piece of vba

Set rs = CurrentDb.OpenRecordset(“SELECT * FROM qryPropertyMatching”, dbOpenDynaset, dbSeeChanges)

The error that is coming back is Too few parameters, expected 3

 

any ideas?

Reply | Quote

Replies

Have you tried running it with just the query name? Meaning, delete the select statement from before the query name.  If that doesn’t solve it, my next stop would be the query itself.

Reply | Quote