Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

show/hide subform

Status
Not open for further replies.

Maca2

Technical User
Joined
May 21, 2001
Messages
5
Location
GB
I want to show a subform only when it contains data in Access 97 (hide when no data). The subform is based on a linked table.
 
Hi

Try something like

If Me.MySubFormControl.FORM.Recordcount > 0 Then
MySubFormControl.Visible = True
Else
MySubFormControl.Visible = False
End If

in the Main for OnCurrent Event Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top