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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|