A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

The disappearing form



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2010, 01:34 PM posted to microsoft.public.access.forms
PA
external usenet poster
 
Posts: 187
Default The disappearing form

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
  #2  
Old April 26th, 2010, 03:57 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default The disappearing form

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

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

  #5  
Old April 26th, 2010, 08:34 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 11:44:02 -0700, PA 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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.