Set the window mode to dialog.

Example: DoCmd.OpenForm "frmLogin", , , , , acDialo

This will keep the form open before the next one is opened.