Prev: Two subforms, one based on selection in the other
Next: Autofill text boxes
From: PA on 26 Apr 2010 08:34
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
From: golfinray on 26 Apr 2010 10:57
If your form is blank, that generally means there was no data there to show.
Make sure your control source on the mainform is correct and that all the
link master-child fields are correct from subform to mainform.
--
Milton Purdy
ACCESS
State of Arkansas


"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
From: John W. Vinson on 26 Apr 2010 12:21
On Mon, 26 Apr 2010 05:34:01 -0700, PA <PA(a)discussions.microsoft.com> 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]
From: PA on 26 Apr 2010 14:44
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 <PA(a)discussions.microsoft.com> 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]
> .
>
From: John W. Vinson on 26 Apr 2010 15:34
On Mon, 26 Apr 2010 11:44:02 -0700, PA <PA(a)discussions.microsoft.com> wrote:

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

I wonder if you perhaps set the Data Entry property of the forms to Yes; and
perhaps the Alllow Additions and/or Allow Edits properties to No.

This symptom means that there are no records in the form's recordset (so you
can't see any existing records) and that the form does not allow additions
either (so you can't see the blank New Record). Is there data in your tables?
What are these properties of the form?
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Two subforms, one based on selection in the other
Next: Autofill text boxes