How to display OpenStoredProcedure result set in child window

[Guest]

Hi, I'm using Access 2003 and using the OpenStoredProecedure method from VBA.
I need to display th result set from this in a child window inside a form in
the application. This does not happen automatically and now the result set
displays in an independent window sitting out there. How do I make it a child
window? Thanks. Eaton

 

[pietlinden]

Hi, I'm using Access 2003 and using the OpenStoredProecedure method from VBA.
I need to display th result set from this in a child window inside a form in
the application. This does not happen automatically and now the result set
displays in an independent window sitting out there. How do I make it a child
window? Thanks. Eaton

why not set the rowsource of the form to the SP? Won't that work? If
you have to, pass the PK from the parent form and get a filtered
subset of data and make that the rowsource for the subform...

 

[Guest]

hi,

No, t hat won't work because the sp creates a variabel number of columns.
There ought to be some way of making this window a child window of another
form or something, right?

Thanks.