Too few parameters error

[danikuper]

I'm populating a listview control with a query from an 'onclick' event of a command button on my form. It all works fine up until the point where I want to supply a parameter (combo box) to my query so I can re-build the listview with the filtered result of my query.

Pasting the SQL code on a new query works, so the error cannot be related to the SQL (right?). Any help in reviewing why I'm getting the "3061: Too few parameters. Expected 1." is greatly appreciated!!!!

Thanks!
daniel

P.S. See attached text file for the code I'm using.

 

[Mile-O]

Type: Too few parameters into the forum's search function and you'll see that you are not the first to ask this.

 

[danikuper]

Yes, I tried that, however the answers given did not help me at all. I'm not a VBA expert so I may have misunderstood some of the directions or applying them to my particular case.

If someone could take a look at my code and point me to the right direction I would be very very very thankful!

daniel

 

[Mile-O]

If someone could take a look at my code and point me to the right direction I would be very very very thankful!

Then poste your code.

 

[Cosmos75]

Microsoft Knowledge Base Article - 209203
ACC2000: "Too Few Parameters. Expected 1" Error Message

 

[danikuper]

Mile, my code is attached to the first message.

thanks.