Disappearing subform in MDE

[Karl Roes]

Hi all,

Why might a subform on a Tab control in an A2003 MDE suddenly decide
to , well, just disappear?
There are no calls to change any visible properties - all I see is
just a faint outline where the form should be. The data in the
datafile is still intact. The RecordSource for the subform is a simple
query.
I've tested the same MDE on an older backup of the datafile and all is
OK - and an older version with the same datafile with the same
problem, so something certainly seems amiss with the current datafile
- but I've imported the data into a new mdb and still the same issues
prevail.

To troubleshoot further, where could I go from here?

Regards

Karl

[Allen Browne]

Permissions?

The entire detail section will disappear if:
a) there are no records to display, and
b) no new records can be added.

You probably know if a) is happening: filter, etc.

Examples of causes for b):
- based on a read-only query;
- its AllowAdditions property is No;
- user has read-only permissions (Access security);
- drive is shared read-only (Windows).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...

Why might a subform on a Tab control in an A2003 MDE suddenly decide
to , well, just disappear?
There are no calls to change any visible properties - all I see is
just a faint outline where the form should be. The data in the
datafile is still intact. The RecordSource for the subform is a simple
query.
I've tested the same MDE on an older backup of the datafile and all is
OK - and an older version with the same datafile with the same
problem, so something certainly seems amiss with the current datafile
- but I've imported the data into a new mdb and still the same issues
prevail.

To troubleshoot further, where could I go from here?

Regards

Karl

[Brian]

"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...

Hi all,

Why might a subform on a Tab control in an A2003 MDE suddenly decide
to , well, just disappear?
There are no calls to change any visible properties - all I see is
just a faint outline where the form should be. The data in the
datafile is still intact. The RecordSource for the subform is a simple
query.
I've tested the same MDE on an older backup of the datafile and all is
OK - and an older version with the same datafile with the same
problem, so something certainly seems amiss with the current datafile
- but I've imported the data into a new mdb and still the same issues
prevail.

To troubleshoot further, where could I go from here?

Regards

Karl

If the subform is background-colour with an outline (as opposed to empty
white space) then it hasn't disappeared. When an Access form does not
permit records to be added (either because it's AllowAdditions property is
set to "No", or it's RecordSource is not updatable) AND there is no data to
display, then none of the controls are visible.

[Karl Roes]

Hi Allen and Brian,

I found the problem. :-)

In one calculated field in one "cascaded" subquery, I didn't allow for
nulls. A quick CCur(nZ(.......)) and all is well.
The problem, of course <grin>, doesn't occur on an earlier datafile
backup because the record causing the problem had not been entered yet
and the different frontend versions all had the same sub query.
Importing the data to a new datafile was, in this case, of no use at
all.

Thanks

Regards

Karl
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...

Permissions?

The entire detail section will disappear if:
a) there are no records to display, and
b) no new records can be added.

You probably know if a) is happening: filter, etc.

Examples of causes for b):
- based on a read-only query;
- its AllowAdditions property is No;
- user has read-only permissions (Access security);
- drive is shared read-only (Windows).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...

Why might a subform on a Tab control in an A2003 MDE suddenly decide
to , well, just disappear?
There are no calls to change any visible properties - all I see is
just a faint outline where the form should be. The data in the
datafile is still intact. The RecordSource for the subform is a simple
query.
I've tested the same MDE on an older backup of the datafile and all is
OK - and an older version with the same datafile with the same
problem, so something certainly seems amiss with the current datafile
- but I've imported the data into a new mdb and still the same issues
prevail.

To troubleshoot further, where could I go from here?

Regards

Karl