Why my form won't appear

Why my form won't appear - MORE INFO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan Bricker - 05 Apr 2008 15:24 GMT

I'm sorry to post twice...but I just traced the problem again and found
additional information

Problem: Attempt to open a form on top of already opened forms results
in screen flash but the desired form does not appear.

I have traced and I am entering the module behind the form (Form_Open
and Form_Load routines). However, at the beginning of Form_Open the
form's VISIBLE property is False. I attempt to modify that variable in
the Immediate window and the value remains "False" (very strange).

I type:
?me.visible

and it says the value is "false"

I then type
me.visible = True

and then

?me.visible
shows
me.visible = False

STRANGE. The value did not change. What's up with that?

Can you point me in the right direction to try to find the cause of the
problem?

Thanks.

Regards,
SueB

Reply to this Message

Tom van Stiphout - 05 Apr 2008 17:05 GMT

Rather than Me, use:
Forms!YourFormName.Visible

You could also search all code and temporarily comment out all lines
that manipulate the Visible property.

-Tom.

>I'm sorry to post twice...but I just traced the problem again and found
>additional information
[quoted text clipped - 32 lines]
>
>*** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message

Susan Bricker - 05 Apr 2008 20:08 GMT

Tony,

Thanks for the suggestion. Unfortunately, that didn't work. The form
still does not appear. I'm really stumped. Funny enough, the form does
display properly when selected from the Main Menu. I've traced the
display of the form from that location and oddly enough the VISIBLE
property is FALSE there, as well. So ... I'm not sure that the VISIBLE
property is the cuprit.

I am so stumped and could really use some help. Thanks for your
attempt.

Regards,
SueB

Reply to this Message

Salad - 05 Apr 2008 20:58 GMT

> Tony,
>
[quoted text clipped - 12 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Could you provide more information? You say it displays fine when
running from the main menu. Is the format
    Docmd.OpenForm "ProblemForm"
with no filter, etc?

When you open the form form code do you open it hidden?
    Docmd.OpenForm "ProblemForm",,,,,acHidden

Do you pass a filter?
    Docmd.OpenForm "ProblemForm",,,"Test = 1",,acHidden

Or do you pass it a filter only
    Docmd.OpenForm "ProblemForm",,,"Test = 1"

Or is the same as from the MainMenu
    Docmd.OpenForm "ProblemForm"

Do you do a Me.Visible = False in the form's code module?

Are the already open forms opened as dialogs (modal)?

Its quite possible there's some flaws in the Open/Load code that simply
crashes the form. Maybe the form's recordsource can't figure out what
to do.

I would check your recordsource. I would attempt to open the form from
a test module with and without filters. I would also copy the form to
another form and remove the Open/Load and possibly OnCurrent code from
that copy and try to open the copy.

Lights On
http://www.youtube.com/watch?v=jjISbPmyX9Y

Reply to this Message

Susan Bricker - 06 Apr 2008 05:22 GMT

To answer some of your questions ...

when opened from the Main Menu the command is just plain 'vanilla', no
filter. When opened from the other form it does have a filter.
HOWEVER, I tried it with no filter, as well, and it did not appear.

As for the forms that are open ... I checked and there are two and they
were not modal, but pop-up was 'yes', so I changed it to 'No' and the
form, still, did not appear. I doubt that it is the recordsource (as
the cause of the problem) because the form opens just fine from the
MainMenu.

Grrrrr.

Regards,
SueB

Reply to this Message

HUSAMDB@gmail.com - 02 May 2008 17:07 GMT

> To answer some of your questions ...
>
[quoted text clipped - 14 lines]
>
> *** Sent via Developersdexhttp://www.developersdex.com***

I had the same problem and all I did was open the form's VB editor and
make a change (and then remove the change) so that when I closed the
form it asked me to save the changes. Once the "changes" were saved,
the form opened again. A very strange glitch.

Reply to this Message

Tom van Stiphout - 06 Apr 2008 03:36 GMT

In addition to Salad's suggestions:
DoCmd.Maximize
in the Form_Open event.

-Tom.

>Tony,
>
[quoted text clipped - 12 lines]
>
>*** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message