Subform opening with no textboxes

[Guest]

Hi there;

I have a series of five subforms which are called on via command buttons on
the main form. All subforms open properly except one. The bad subform, when
opened, displays the labels but none of the associated text boxes for them.
So basically there's no way of entering data. Thing is, if I open this
subform independently of the main form, it works fine.
The way I set it up is that the labels reside in the form header, and the
associated text boxes reside in the detail section of the continuous form. I
tried comparing this bad subform against all the good ones, but I don't see
any discrepancies with how it's set up. Why would the subform work on its
own yet not when it's called upon by the main form? Its command button looks
ok, as far as I can tell.
Any help would be appreciated.

Casa

 

[Sandra Daigle]

This happens to a form when certain conditions exist:

1) The recordsource query returns no records
2) The AllowAdditions property of the form is False
3) The DataEntry property of the form is false.

Change either 2 or 3 and your form controls should appear. Here are some
articles that describe other reasons why this could occur:

ACC2000: Form Appears Blank When Opened Except for Header
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209617

ACC2000: Form Opened in Form View Is Completely Blank
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209734

 

[Guest]

Thank you very much. I will check out those links!

This happens to a form when certain conditions exist:

1) The recordsource query returns no records
2) The AllowAdditions property of the form is False
3) The DataEntry property of the form is false.

Change either 2 or 3 and your form controls should appear. Here are some
articles that describe other reasons why this could occur:

ACC2000: Form Appears Blank When Opened Except for Header
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209617

ACC2000: Form Opened in Form View Is Completely Blank
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209734

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hi there;

I have a series of five subforms which are called on via command
buttons on the main form. All subforms open properly except one.
The bad subform, when opened, displays the labels but none of the
associated text boxes for them. So basically there's no way of
entering data. Thing is, if I open this subform independently of the
main form, it works fine.
The way I set it up is that the labels reside in the form header, and
the associated text boxes reside in the detail section of the
continuous form. I tried comparing this bad subform against all the
good ones, but I don't see any discrepancies with how it's set up.
Why would the subform work on its own yet not when it's called upon
by the main form? Its command button looks ok, as far as I can tell.
Any help would be appreciated.

Casa

 

[Guest]

As it turned out, if I opened the bad subform up independantly of the main
form, it didn't work fine. I couldn't add more data to it. So I looked at
the underlying query, which consisted of a table joined to another query.
When I ran this query, it didn't contain an extra line to add more data. So
I checked the sub-query. That was fine. I ended up checking the two source
tables, and changed the primary key on one of the tables to the field that I
was using to for joining in the main underlying query. Then everything
worked fine.

This happens to a form when certain conditions exist:

1) The recordsource query returns no records
2) The AllowAdditions property of the form is False
3) The DataEntry property of the form is false.

Change either 2 or 3 and your form controls should appear. Here are some
articles that describe other reasons why this could occur:

ACC2000: Form Appears Blank When Opened Except for Header
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209617

ACC2000: Form Opened in Form View Is Completely Blank
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209734

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hi there;

I have a series of five subforms which are called on via command
buttons on the main form. All subforms open properly except one.
The bad subform, when opened, displays the labels but none of the
associated text boxes for them. So basically there's no way of
entering data. Thing is, if I open this subform independently of the
main form, it works fine.
The way I set it up is that the labels reside in the form header, and
the associated text boxes reside in the detail section of the
continuous form. I tried comparing this bad subform against all the
good ones, but I don't see any discrepancies with how it's set up.
Why would the subform work on its own yet not when it's called upon
by the main form? Its command button looks ok, as far as I can tell.
Any help would be appreciated.

Casa

 

[Sandra Daigle]

Glad to hear it - I forgot to mention that a read-only query could cause the
same problem!

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

As it turned out, if I opened the bad subform up independantly of the
main form, it didn't work fine. I couldn't add more data to it. So
I looked at the underlying query, which consisted of a table joined
to another query. When I ran this query, it didn't contain an extra
line to add more data. So I checked the sub-query. That was fine.
I ended up checking the two source tables, and changed the primary
key on one of the tables to the field that I was using to for joining
in the main underlying query. Then everything worked fine.

This happens to a form when certain conditions exist:

1) The recordsource query returns no records
2) The AllowAdditions property of the form is False
3) The DataEntry property of the form is false.

Change either 2 or 3 and your form controls should appear. Here are
some articles that describe other reasons why this could occur:

ACC2000: Form Appears Blank When Opened Except for Header
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209617

ACC2000: Form Opened in Form View Is Completely Blank
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209734

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hi there;

I have a series of five subforms which are called on via command
buttons on the main form. All subforms open properly except one.
The bad subform, when opened, displays the labels but none of the
associated text boxes for them. So basically there's no way of
entering data. Thing is, if I open this subform independently of
the main form, it works fine.
The way I set it up is that the labels reside in the form header,
and the associated text boxes reside in the detail section of the
continuous form. I tried comparing this bad subform against all the
good ones, but I don't see any discrepancies with how it's set up.
Why would the subform work on its own yet not when it's called upon
by the main form? Its command button looks ok, as far as I can
tell. Any help would be appreciated.

Casa