View Single Post
  #4  
Old April 26th, 2010, 07:44 PM posted to microsoft.public.access.forms
PA
external usenet poster
 
Posts: 187
Default The disappearing form

Thank you for the replies.
Basing the form(s) on the tables is what I did. Not only do the controls
disappear but the labels also disappear. I am at a loss to explain it.

"John W. Vinson" wrote:

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