Form disappears when set to Pop Up = Yes

[tad0075]

In Access 2010, I can't get a form to show up in Pop Up mode without it disappearing. Tried several solutions (most from this message board) with no luck, including:

Set Modal = no
Set Auto Resize = no
Set Auto Center = no
Set Border Style = dialog

More info:
There isn't any VBA set to run when the form opens, only on button clicks.
I'm able to call out the form to open as acDialog in vba, but this blocks additional code I need to prepopulate the form.
So far this happens on all forms I try to set as Pop Up.

Any other solutions?

Thanks,
Tyler

 

[vbaInet]

What happens when you don't set it as a Popup form?

 

[tad0075]

What happens when you don't set it as a Popup form?

It appears as a tabbed form with no obvious problems.

 

[vbaInet]

I don't understand what you mean by a tabbed form. Do you mean it has a tab control in it?

 

[tad0075]

Tabbed form:
https://plus.google.com/105344220430865949067/posts/Q8DkZQ48dDF

 

[vbaInet]

Ok, it's not a tabbed form. It's a Single Form. The tab is just the layout applied to all objects, i.e. forms, queries, macros and reports.

Do you know how to get to the Immediate Window?

 

[tad0075]

I found it, but I've never used it before. Can you guide me through what to look for?

 

[vbaInet]

1. Open the form as a Popup
2. Go to the immediate window and enter this:

?Forms("[COLOR="Blue"]FormName[/COLOR]").WindowTop

3. And hit enter
4. Do the same for WindowLeft as well

Tell us what values come up.

 

[tad0075]

WindowTop returns 0
WindowLeft returns 1

 

[vbaInet]

Well that's peculiar!

Do the same for the Visible property.

 

[tad0075]

Visible returns True

 

[vbaInet]

The plot thickens!

Can you upload a sample db with one of the forms?

 

[tad0075]

Sample attached.

 

[vbaInet]

Try the attached.

 

[tad0075]

Success!

That was quick, what did it take to fix it?

 

[vbaInet]

There's something weird going on with your form.

Open the form in design view:
1. Set the Auto Centre, Auto Resize and Fit To Screen properties to No. If any of the options is No, still change it to Yes and switch it back again to No.
2. Close and save the form (when it prompts you). Not the other way round.
3. Open the form to test that it works as expected
4. Open it again in design view and set the Auto Centre and Auto Resize properties back to Yes
5. Close and save the form when prompted.

 

[tad0075]

That's odd.

It's still behaving a little strangely. I can open the form from the objects pane, and I can call it out from another form using VBA, but when I try to switch from Design view to Form view, it disappears like before. It won't be a problem for the end users, so I'll just learn to live with it.

Thanks for your help!

 

[vbaInet]

Did you follow the steps as described and to the letter?

 

[tad0075]

Yes, but it never worked as expected on step 3.

I can live with it as it is now, since it will work correctly for the users.

 

[vbaInet]

I think you should re-install your Access. I'm sure it will be a pain in the future if you continue developing and your app gets bigger.