Selecting Connections in BusObjs Using VBA

[Benedict]

How do I create a prompt for the User to select a Connection for a Universe when refreshing/creating a document? We're using full client and VBA.

 

[mustang7]

a) Create an object in Designer and the build a condition in the Query Panel which will prompt the user for a value, the assign it to the connection.

OR

b) Create a UserForm with the selection of Connections on offer. Call it from the BeforeRefreshEvent.
There is a Connection Object in BO and in Designer, both related to the Universe in use.