Missing Form View

[lovespar]

I have a front end containing some 60 forms with subforms. Somehow all the
forms connected to one Tabular object (?) show blank. I can see the forms in
design view, can see the headers in datasheet view, but cannot see anything
in Form view which is where we want to input our data. I have checked all the
hidden properties,
imported to a new DB and checked my tape backups. It seems as though
everytime I open a backup, the forms disapear again. I am using a backup from
a date where I know the forms were there because it is our monthly metrics
and I did an upload from them last month. I can delete the data source from
the properties of the form and I get the Form view with errors in all the
fields. I can add a new form on a new tab and it wll show in form view.
Before I set about recreating 45 forms, has anyone run in to anything like
this before?
Thanks for any input

 

[Rick Brandt]

I have a front end containing some 60 forms with subforms. Somehow
all the forms connected to one Tabular object (?) show blank. I can
see the forms in design view, can see the headers in datasheet view,
but cannot see anything in Form view which is where we want to input
our data. I have checked all the hidden properties,
imported to a new DB and checked my tape backups. It seems as though
everytime I open a backup, the forms disapear again. I am using a
backup from a date where I know the forms were there because it is
our monthly metrics and I did an upload from them last month. I can
delete the data source from the properties of the form and I get the
Form view with errors in all the fields. I can add a new form on a
new tab and it wll show in form view. Before I set about recreating
45 forms, has anyone run in to anything like this before?
Thanks for any input

A form's detail section is completely blank when both of the following are
true...

1) There are no current records to show
2) There is no ability to add new records

Point (1) can be caused by...

No data in the underlying tables
No data as the result of joins in a query
No data as the result of criteria in a query
Filters applied to the form

Point(2) can be caused by...

Properties of the form
AllowAdditions = No
RecordSetType = "Snapshot"
User Level Security
Properties of the underlying RecordSource (if a query)
RecordSetType = "Snapshot"
All reasons that make a query's output be read only
(there is an entire help topic describing this one)

The normal "blank form" that you might be expecting where you see all of your
controls but they contain no data is actually the new record position of the
Form's RecordSet. That position does not exist if any of the above prevent you
from using the Form to enter new records. What you get instead then is the
completely blank detail section that you are seeing now.

When people are surprised by this result it more often than not means that they
bound the form to a query without realizing that the query produces read only
output.

 

[lovespar]

Dear Rick,
You are the Master! On all these forms somehow the Allow Additions was set
to NO.
You have saved me hours of work recreating forms and subforms. I don't know
to protect myself form this happening again, having no clue how it happend
this time but at least now I can fix it.
Thanks again