Solved Open form to front

[Kayleigh]

Hi
I have a simple question but cannot seem to find a satisfactory answer.
I would like to open a form (not pop-up) and it should display at front of other forms. I tried playing with visible settings but didn't help. The only way to get it to display was the 'Modal' setting to True but this means nothing else can occur whilst form is open so would like another solution if possible.

 

[theDBguy]

How are you opening the form? Using code?

 

[Kayleigh]

For example:

DoCmd.OpenForm "frmMarketingCampaigns"

 

[theDBguy]

For example:

DoCmd.OpenForm "frmMarketingCampaigns"

And is that the only code in your procedure? I am wondering if you have the code doing other things after you open the form, which could take the focus away from the form you just opened.

 

[Kayleigh]

The only other code is:

Me.visible = false

 

[theDBguy]

The only other code is:

Me.visible = false

Try swapping those two lines around.

 

[LarryE]

What do you think Me.Visible = False does?

 

[Kayleigh]

@theDBguy - thanks for persevering. I've sorted issue. It was just the order of my lines of code.

 

[theDBguy]

@theDBguy - thanks for persevering. I've sorted issue. It was just the order of my lines of code.

Glad to hear you got it sorted out. Good luck with your project.