>I have declared a PUBLIC recordset object. However intellisense does not work when i try to use the object inside a function, even if it's in the same file. Is there a reason? Any alternatives I can use?

Intellisense doesn't look outside of the current function to get variable types. The alternative is, assign the public variable to a local one, and use the LOCAL AS.

One thing, why are you using a public object? There is almost always a better solution than a public variable.