Form set focus

[alpapak]

i have a db with many forms.
i want to set focus or better always on top the last open form
example:
the forms are open like this

mainform
2form
3form
4form

i want to set focus or always on top 4form
if 4form close the next form is 3form
if 3form close the next form is 2form
if 2form close the next form is mainform

thxs

 

[KjWhal]

i have a db with many forms.
i want to set focus or better always on top the last open form
example:
the forms are open like this

mainform
2form
3form
4form

i want to set focus or always on top 4form
if 4form close the next form is 3form
if 3form close the next form is 2form
if 2form close the next form is mainform

thxs

Add a OnClose Event to each form such that

Forms[form name of form you want to have focus if this form is closed].SetFocus

 

[Bat17]

look up 'popup' and 'modal' in help and see if that helps

Peter