Everythings Gone !!!

[MFS]

I opened my database that I am currently building and everything is gone from the main form. Command Buttons, date/time, etc.
In Design view it's all there, Form view gone.
Can anyone shed some light on why this could be happening?


Mike

[CGM3]

Sometimes it's the simple things...

Is the Visible property for each control set to Yes/True? Is there code in the Form_Load event that sets those Visible properties to No/False?

[MFS]

Yes, each item on the form is visible, set to true. And there is no code in the Form_Load.
When first opening the database this morning all was working fine. I deleted some junk data from a table and when returning to the main form all command buttons were missing.
Weird!!!, I'm actually thinking of rebuilding the form.

[MFS]

Okay,
I have a trending graph on the main screen. It seems when I deleted the data that pertained to that graph it not only removed the data points on the graph on the main form, as it should, but took all command buttons of the form as well. Why I can't explain??
I added some junk data back into the table and all controls returned.

[Missinglinq]

...Why I can't explain...

This phenomenon occurs when

1. A Form is Read-Only, i.e. cannot have new Records added
2. There is no data in its RecordSource.

The first condition is apparently true, and deleting the data satisfied the second condition!

Linq ;0)>

[MFS]

Yes, a form is read only, not denying, however I have a graph on the form that has a record source being a query designed from a table. When I deleted all data from the table for some reason caused all control on the form to be gone. (Command buttons, close database, date & time, labels, lines and images that were not affiliated with the table to disappear.)

[Missinglinq]

...form is read only...

...When I deleted all data from the table...

Don't know how else to say this, if a Form is Read-Only and there is no data in the Form's RecordSource, this phenomenon is going to occur!

The graph (Chart) doesn't have a Record Source.

Linq ;0)>

[MFS]

Ahhh, Ok, Got ya. Yes you are correct. That is the what has happened.