=> Don't know what I've done not able to View Form

[Rhonda Fischer]

Hello,

I am trying to 'Open' or select 'Design View' on
my form and neither works when I right click on the
form name and select either option.

I'm not sure what I have done?

Any ideas?

Thank you kindly
Rhonda

 

[Katrina]

Have you tried a compact and repair? Sometimes this will help.

Kat

 

[Rhonda Fischer]

Hello Kat,

I was trying this piece of code:

With Forms!frmOrderSheet!frmOrderSheetSub
.Visible = Not .Visible
End With

Not sure if part of the problem. I can see the
form in the view code project window, and the code
I have put behind the form, but can't see the form
itself.

I tried a button on a new form simply calling my
listed but not accessible form:

DoCmd.OpenForm "frmOrderSheet"

but it comes up with the error msg:

Run-time error '2001':
You canceled the previous operation

Still a mystery, compact and repair didn't solve
the problem, though I appreciate you response very much.

Any other ideas?

Thank you kindly
Rhonda

 

[Marin Kostov]

Open the form in the view you can (if there is an option of course).
Open the Properties page, and in the Format tab check the Allow ...View.

 

[Van T. Dinh]

The piece of code only hides the SubformControl so it shouldn't be the cause
of the problem.

Error 2001 is consistent with the fact that Access can't open the Form for
some reasons and your CommandButton_Click event will give you this error.

It sounds to me that there are corruptions in your database, possible the
Form frmOrderSheet. Try create a new database and import all objects from
the existing database.

If it doesn't work, cretate a new database,and import all objects except the
frmOrderSheet. Hope fully, you have a back-up somewhere with a good copy of
the Form frmOrderSheet you can import from.