Subform disappears from main form if no records

[John S. Ford, MD]

I have a form with an embedded subform. Things seem to work OK unless the
condition arises that the subform has no corresponding records. In that
situation, the subform just disappears in a field of gray from the main
form. The problem is that the sub form contains a series of buttons that
serve to add new records to the subform. Unfortunately the buttons
disappear as well.

Anything I can do about this? Will I simply have to recode everything with
a new set of buttons (and their even handlers) placed on the MAIN form where
they'll look somewhat out of place?

Thanks in advance,
John

 

[Reggie]

John, Sounds like you have your subform set to AllowAdditions = No and that
the buttons are in the detail section of the subform. If that's the case
you can set allowadditions = Yes or move your buttons to the Header/Footer
of the subform.

Hope this helps!

 

[Neil]

Hello John,

This happens when you have Allow Additions set to No. As you have set this
to No, Access protects the form automatically by hiding all the controls on
it. There is a solution however. You can either set Allow Additions to Yes
or place the buttons in the forms Header or Footer sections (not page
header/footer).

HTH,

Neil.

 

[John S. Ford, MD]

Thanks, that solved the problem!

John