i have a stored query in my database and when i run it from vb code using

DBEngine(0)(0).Execute "QRY_ImportDuplicatesTopLevel", dbFailOnError

i get the message "an error ocurred 3061 - too few paramters expected 1"

which usually means a missing or mispelled field name

however when i run this query by double clincking its icon i get no error and the query returns the appropriate data

does anyone know what may cause this divergent behaviour?

i found the (stacked) query that was cauzing the problem but i still don't know why it was letting me run from the queries icon but i can sort this problem now