View Single Post
  #3  
Old April 26th, 2010, 05:21 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default The disappearing form

On Mon, 26 Apr 2010 05:34:01 -0700, PA wrote:

In using Access 2007, I have a database with five joined tables. I want to
make a form, based on the "main table" and then four individual subforms.
This works fine for the first of the four subforms, but when I add the second
in design view, and then look at my handy work in Form View, all I have is a
blank, white display, none of the controls are visible. This is the most
complex form I have ever attempted and can not determine what is wrong.
Please help.
Paul


It sounds like you're trying to create a five table query and use that query
for your form. This won't work (a blank form means that the form's
Recordsource returns no records and is not updateable).

Instead, base the main form on the master table, and base each subform on one
of the related tables. You don't need a big complicated query in order to get
a big complicated form g...
--

John W. Vinson [MVP]