multiple forms

[DanielR]

My forms have popup -> yes and modal -> yes.
When I close my current form I get the save window pop up however it does it on the parent window and the current window is now behind the parent window.
How can I ensure that the Parent window doesn't appear until the current window is closed?

 

[arnelgp]

You need an API to Set the pop up to Foreground

 

[arnelgp]

add copy and paste in a module.
on your pop up form Open Event:

Call SetForegroundWindow(Me.hwnd)

#if VBA7 then
	#If Win64 Then
		Declare PtrSafe Function SetForegroundWindow Lib "user32" (ByVal hWnd As LongPtr) As Long
	#else
		Declare PtrSafe Function SetForegroundWindow Lib "user32" (ByVal hWnd As Long) As Long
	#end if
#Else
	Declare Function SetForegroundWindow Lib "user32" (ByVal hWnd As Long) As Long
#End If

 

[Frothingslosh]

There's absolutely no need to use an API call for this.

When I'm using that kind of setup, I set the parent form to Hidden in the child form's Open event, and then set it back to visible in the child form's Close event (which technically runs before the form closes, but you won't normally be able to tell that).

And Pat's right - you shouldn't be getting a save popup when you close a form. Are you possibly modifying the record when the form opens? That would cause Access to ask if you want to save the record.

If it's asking you to save changes to the form itself, you can get around that by disabling the X-out button at the top-right of the form, and providing a close button instead. Have the close button use this code:

DoCmd.Close acForm, Me.Name, acSaveNo

Or shorten it to DoCmd.Close , , acSaveNo and you'll be fine like 99% of the time.

 

[Frothingslosh]

Blech, you're right, dunno how I forgot that.