Scope of a recordset

[andrey_anikin]

Gentlemen,

I have an issue with the scope of a recordset. I declare it as Public in the General Declarations section of a form module, and it works fine throughout that module; then I need to use it in another form module - and here's where the problems begin: it looks like Acsess just doesn't see that object if I refer to it from a different form module than its original one. What am I doing wrong and is there a way out?

Thanks in advance!

 

[pbaldy]

Declare it in a standard module, not a form module.

 

[andrey_anikin]

Looks like it helped... thanks!

 

[gemma-the-husky]

its the scope of the form module - it only has scope to the form it is attached to - you need a generral module to have global scope

 

[andrey_anikin]

Thanks again, this is the right way