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!!

On Wed, 5 May 2010 13:38:01 -0700, TechieMom
<TechieMom@discussions.microsoft.com> wrote:

>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?

-- 

             John W. Vinson [MVP]

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 ...




"John W. Vinson" wrote:

> On Wed, 5 May 2010 13:38:01 -0700, TechieMom
> <TechieMom@discussions.microsoft.com> wrote:
> 
> >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?
> 
> -- 
> 
>              John W. Vinson [MVP]
> .
> 

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!! :)

"TechieMom" wrote:

> 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!!

On Wed, 5 May 2010 15:41:01 -0700, TechieMom
<TechieMom@discussions.microsoft.com> wrote:

>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.
-- 

             John W. Vinson [MVP]