Subject Re: invalid subscript reference From Mervyn Bick <invalid@invalid.invalid> Date Tue, 22 Sep 2020 11:34:39 +0200 Newsgroups dbase.getting-started On 2020/09/22 10:49, Gaetano wrote: > > HI All, > > I am getting an invalid subscript error that I can't troubleshoot... > > Here is the code, the first ADO query works fine, the second one gives > me an invalid subscript error on the second param, while it  is exactly > the same as the previous one, I put in a msgbox to verify the values and > they are correct. The queries look similar except for the order by clause in the second query.  As each query should only produce one record in the result set an order by clause is redundant.  The fist thing to do is remove the order by clause and see if that makes a difference. Mervyn.