Dec 23, 2002 #1 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.
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.
Dec 23, 2002 #2 KenReay Programmer Joined Aug 15, 2002 Messages 5,424 Location GB 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 - http://www.kenneth.reay.btinternet.co.ukUK Upvote 0 Downvote
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 - http://www.kenneth.reay.btinternet.co.ukUK