Data exchange - MDI - Child - Parent

[Mart]

Hi, I need your advice for this.

I would like to have an object that access the DataBase, let's name it
objDB. This objDB object would be held by the MDI Parent.

The MDI Child would use the objDB to execute SQL query and get recordset
result.

Am I right to store this objDB in the MDI Parent? Because many MDI
Child could use it.

Thanks a lot

 

[EricJ]

why not (you could also put it in a module)

be sure to declare it as a public shared var

hope it helps

eric

 

[Mart]

In a module, very nice. And you know what, I did it many time for other
applications. And now because I involve DB and MDI stuff, it's like if
I had never done that (a glitch in my brain? hehehe).

So this is what I will do, I will declare it public in a module.

Thank you EricJ, your tip is appreciated

Mart