saving a value for reference, open a form by using HWND

[Mr.K]

How can I save a number with vba so that I can later reference it (collections?). I wish to pass a HWND value of an instance of a form and later set focus back to that form using that value.
My other question is how do I refer to a form using the HWND (and form's control)?

 

[Oldsoftboss]

Do you want to save this number even after the Db is closed or will it be re-used. The simplest way would be to create a table with only one field and one record. This could be sourced through Dlookup or having the table bound to a hidden form.

Dave

 

[Mr.K]

I don't need to have this number after the DB is closed. I guess I ould use a table with one field. I thought using collections would be more proper thing to do, but I'm not to familiar with them.

How can I open a form when I have its window handle? Or to be more exact requery a subform on the form to which I have the window handle.