Determining which form is in front

[grenee]

Good day all.

When a click a button on form "Order Details" it opens form "Products". "Order Details" remains in the foreground and "Products" opens in the Background. This restricts access to "Products" unless "Order Details" is minimized or closed (neither of which I would prefer). I want "Order Details" to remain open in the background and "Products' to remain open in the foreground.

Can anyone offer any assistance?

 

[CJ_London]

make your products form popup and perhaps modal if required see these links for greater understanding

https://msdn.microsoft.com/en-us/library/office/ff821033.aspx
https://msdn.microsoft.com/en-us/library/office/ff845183.aspx

note if you just have the form as popup and not modal and it is within the boundaries of your order details form, the user can click on order details and it will bring this from to the fore, thereby hiding the products form as you experience at the moment

 

[grenee]

Thanks for the direction.

I followed the link but it is difficult to follow because I cant find the referenced popup properties anywhere on my property sheet.

I am able to select the "product" form by the "Order Details" form remains in the way blocking the others.

 

[CJ_London]

popup and modal can be found under the 'other' tab of form properties

 

[grenee]

Thanks.

I found it.

 

[grenee]

Question:

Can a popup show only I record? Or can it be set to show all records?