Hello Fernand, > I trye to pass a nwe connection to a already opened form document who > contains the macro a running from.
You cannot do this. ActiveConnection is only accepted when the form is being loaded, after that, any change to it is vetoed, since the assumption is that the form, living in the database document, always uses the connection which the main database window already established. Also, in the scenario you described - two forms in the same database document - there should be no need at all to change the active connection of the already-loaded form. What do you want to achieve with this? Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
