If I recall, you cannot debug these due to some limitation/bug in VB/VBA.  You'll need to run the macro and use msgbox to get the name of the popup form.  Otherwise, what you're doing looks correct.  Note that you can use the same datasource variable when you connect to the popup so you can assign the popupdss to your existing variable and when the popup closes you can assign it to the DS on the main UI.  That was you only have to write one set of event code for that datasource.

If I recall, you cannot debug these due to some limitation/bug in VB/VBA.  You'll need to run the macro and use msgbox to get the name of the popup form.  Otherwise, what you're doing looks correct.  Note that you can use the same datasource variable when you connect to the popup so you can assign the popupdss to your existing variable and when the popup closes you can assign it to the DS on the main UI.  That was you only have to write one set of event code for that datasource.

Yap I did get the Form from the msgbox. But seems the datasource event is not bound to it. So it does not trigger the event until I closed the popup

The only way that I can get it to work the way that you want (which is the correct way) is to do the customization using VB 6 and not VBA. In addition, you must run the .exe - it doesn't work when running the program in the VB IDE.

Wow, thats a problem then. If we run from VB6 then we are unable to use the current sign in, also another problem then. Thanks Django for your help

You can add an argument in an icon on the desktop of $objecthandle$ that your VB screen can use to log into the current session.