Detail Section

[Dave Ruhl]

I have a form with a TabCtl object in the Detail
section. The TabCtl has 2 tabs, and each has a subform
embedded into it. When when of the subforms has a no-
records-found condition the entire Detail section goes
blank (even objects outside the TabCtl). Is there any way
to fix this ? I would like to see the other objects in
the detail section even if the subform has no data.
Thanks !

 

[Allen Browne]

The detail section goes completely blank if there are no records to show AND
no new records can be added.

Unless the subform is based on a read-only query, you may be able to work
around the problem by setting its AllowAdditions property back to Yes, and
then cancelling the Form_BeforeInsert event if the user attempts to enter
something.

If that's not suitable, you may be able to display the Form Header/Footer
sections of the subform (assuming Form or Continuous view, not Datasheet).
Controls in the header and footer are visible, though they don't always
display correctly as discussed at:
http://allenbrowne.com/bug-06.html

If the subform's query is read-only and you are getting desperate, you may
be able to UNION some Null values into the source query.

 

[Dave Ruhl]

Thanks for the suggestions. I will try setting the
AllowAdditions to Yes, but lock all of the fields on the
subform... that may work. Thanks again.