How to check the status of a sub form

[S. van Beek]

Dear reader,

If there are no records available for a sub form the sub form will not show
any thing in the form, the sub form is closed.

Is there a code in VBA to check the status of the sub form, closed or open.

Thanks for any help.

Simon van Beek

[Tom van Stiphout]

On Wed, 21 Sep 2005 15:30:30 +0200, "S. van Beek" <S.******@HCCnet.nl>
wrote:

Not all subforms behave that way. Just check out the Orders form in
the Northwind (Noordenwind?) sample database. You may have chosen a
peculiar set of form properties.

You can check for zero records with the resordsetclone:
if me.mysubformcontrol.form.recordsetclone.recordcoun t = 0 then
msgbox "Zero"
end if

-Tom.

Dear reader,

If there are no records available for a sub form the sub form will not show
any thing in the form, the sub form is closed.

Is there a code in VBA to check the status of the sub form, closed or open.

Thanks for any help.

Simon van Beek