Retrieve/display a modal form after break mode

[diberlee]

Hi,

Hoping this is a simple one, my Google-Fu is letting me down today.

I'm trying to debug an issue with a form that's misbehaving. One of my VBA functions isn't working quite right, so I'm adding breakpoints to figure out what's going wrong. The problem I'm having is that each time I enter break mode the form hides itself behind the other form that I have open and I can't figure out how to bring it back into the foreground. I know I can disable the modal property, which is what I've done for now but is there another way to deal with this?

The issue I'm investigating only seems to occur when the navigation pane is disabled, so closing the first form isn't an option as that opens a particular record in the form I'm having trouble with

 

[diberlee]

Switch modal off for Testing?

That's what I went with, but I've been caught out by that before. Is this just another of those little irritating things that are so common in Access?

 

[isladogs]

closing the first form isn't an option as that opens a particular record in the form I'm having trouble with

As an alternative to switching off modal mode, you could try bypassing the first form by doing the following in the VBE Immediate window :
1. set the conditions for that particular record
2. open the form using DoCmd.OpenForm etc

That's worked for me in similar situations ...