USING SQL IN A CLASS MODULE WITH ADO

[TNN]

How do you pass a parameter to a SQL statement that is in a class module??
Can't use:
Set rst = cmd.Execute(Parameters:=string) because being a class module I can't pass a string argument to it nor can I declare a public variable that the class module will see.

As I understand it a class module is private by default, meaning you cannot call to it's subs and the class module will not recognize any public variables outside the class module.

I AM USING THE CLASS MODULE AS A DATASOURCE.

Is there a way????
Thank You in advance, anyone.
TNN, Tom
TNPAYROLL@AOL.COM [sig]<p>TOM<br><a href=mailto:WWW.TNPAYROLL@AOL.COM>WWW.TNPAYROLL@AOL.COM</a><br>[/sig]