View Single Post
  #3  
Old May 5th, 2010, 11:41 PM posted to microsoft.public.access.forms
TechieMom
external usenet poster
 
Posts: 3
Default Page displaying in design view, but layout view shows blank sc

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