CODEWITHSUNDEEP
ms-accessms-access-2007
noelmcg
noelmcg

Reputation: 1067

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 essentially 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

Upvotes: 0

Views: 335

Answers (2)

Fink
Fink

Reputation: 3436

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

Upvotes: 0

iDevlop
iDevlop

Reputation: 25252

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

Upvotes: 2

Related Questions