Make a pop form the only enabled form - MS Access

thanks in advance for any help

I am trying to figure out how to make pop-up sub form the only available focus for a user in a database. So that the user is esse开发者_JAVA百科ntially forced to complete/save/close the sub form, before they can return to the parent form. This I imagine involves disabling the parent form and trying to keep it at the bottom of the pile so to speak.

Im trying to do this in vba as a public subroutine, unfortunately I'm not getting very far! It would seem to me that this type of functionality would be quite common place when pop up forms are used, am I overlooking a common feature?

Any guidance would be greatly appreciated.

Cheers

Noel

Very simple:
DoCmd.OpenForm kfrmArt,acNormal,,,,acDialog
This will stop all processing the next lines until your form closes.

You can also set the form's modal property to true. Here is documentation on it: http://msdn.microsoft.com/en-us/library/aa195316(office.10).aspx