I'd like to implement an interface like the one in the ADO command / parameter object so i can use syntax like:

mQry.add(0) = "value" rather than having to explicitly use (for example) : mQry.Paramters.add "value"


I'm using a collection class to do it at the moment and know i need to use add within the class but at the moment i can't pick up the value as it seems way out of scope.


Any ideas / code welcome.