Page displaying in design view, but layout view shows blank screen

T

TechieMom

I have a multi-page form where each page displays a different subform, for a
total of 10 pages. This is a database/form setup that has worked for years,
but now I've encountered a strange issue in Access 2007.

9 of the 10 pages display with no problems; one page however comes up blank.
If I look at the design view for just that page, it displays correctly, but
the layout view gives me just a blank white screen/page. If I look at the
page from within the main form, it displays correctly in design view, but
when switching to layout view, the rest of the form displays correctly and I
still get the blank page in place of where page 2 is supposed to be.

From what I can tell (I'm not very well versed in Access), all the pages are
set up the same way as far as source objects, all point to the same form for
the record set, etc. And like I mentioned above, it's been working for years
on previous versions of Access with no trouble.

Any ideas? Let me know if I can provide additional details that might shed
some light - I'm rather stumped at the moment! Thanks so much!!
 
J

John W. Vinson

9 of the 10 pages display with no problems; one page however comes up blank.
If I look at the design view for just that page, it displays correctly, but
the layout view gives me just a blank white screen/page.

That symptom suggests that two things are true:

- the Form's Recordsource contains no records (or they're all being filtered
out) so you can't see any existing records
- the form is also not updateable, either because its Allow Updates or Allow
Additions property is turned Off, or more likely because it's based on a query
which is not updateable; so you won't see the empty New Record either.

What is this page (I presume containing a subform??) displaying? If it's a
Subform, what's the subform's Recordsource?
 
T

TechieMom

Yes, it's a subform. Basically, the whole thing a very lengthy evaluation
form for a project that we broke into pages to make it easier for the
evaluators to fill in. Each project being reviewed is a row entry in the
table. Each page contains a subform with input boxes for part of the
evaluation data; the reviewers open a main form and flip thru the pages via
tabs across the top to enter data for each section. So all 10 pages/subforms
are updating the same table (in fact, the same record) until the reviewer
goes to the next record and repeats the process.

I know the recordsource DOES contain records - I have verified this visually
(looking at the table data itself) and the other pages/subforms pointing to
the same recordsource show the data just fine.

As for the Allow Updates or Allow Additions properties, I can check those,
but as I said before I compared the working subforms/pages to the one that is
not working and they all appear to be set up identically.

Since nothing changed from the previous years' database to this one except
for the version of Access we're reading it on, I'm afraid it may be some
random glitch related to the MS Office version changes ...
 
T

TechieMom

OK, it appears there was a random filter on that subform that did not exist
on the others; apparently the filter evaluated TRUE on older versions of
Access but did NOT evaluate the same way in Access 2007 :S Strange, but
thanks for pointing me in the right direction; it was GREATLY appreciated!! :)
 
J

John W. Vinson

Yes, it's a subform. Basically, the whole thing a very lengthy evaluation
form for a project that we broke into pages to make it easier for the
evaluators to fill in. Each project being reviewed is a row entry in the
table. Each page contains a subform with input boxes for part of the
evaluation data; the reviewers open a main form and flip thru the pages via
tabs across the top to enter data for each section. So all 10 pages/subforms
are updating the same table (in fact, the same record) until the reviewer
goes to the next record and repeats the process.

Ummm... I'd suggest a different approach. For one thing, if the record has so
many fields that this is necessary, your table design may require
reevaluation! A 30-field table is getting pretty wide already!

Secondly, it's perfectly possible to have a Tab Control with multiple pages,
with a modest number of controls on each page, all bound to the same record on
the same table.
I know the recordsource DOES contain records - I have verified this visually
(looking at the table data itself) and the other pages/subforms pointing to
the same recordsource show the data just fine.

As for the Allow Updates or Allow Additions properties, I can check those,
but as I said before I compared the working subforms/pages to the one that is
not working and they all appear to be set up identically.

Since nothing changed from the previous years' database to this one except
for the version of Access we're reading it on, I'm afraid it may be some
random glitch related to the MS Office version changes ...

Wouldn't be the first time, alas! You might want to delete this subform;
compact and repair the database; and recreate the subform (and its query) from
scratch, just in case it has some embedded problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top