By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

SubForm is not visible

P: n/a
Dear reader,

In case I have selected a record in the main Form which has no reference
records in the SubForm the SubForm is not visible.

Is there a possibility to check of the record collection for the SubForm is

Or a check on the status of the SubForm, visible yes or no (or False or

Thanks for any help.

Kind regards,

Simon van Beek
Jan 18 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
One quick way to check for relevant records is using DCount. Something

If DCount("SomeField", "Table", "SomeField='" & strSomeVariable & "'")
0 Then

' whatever code you want to execute
' if there is a relevant record, like
sfmSubform.Visible = True
End If

Like any control, you can check to see of the subfom is visible by
referncing it's 'Visible' property:

If Forms("FormName").sfmSubform.Visible Then
End If

Not sure if that answers your question???

Jan 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.