ACCESS FEED: RE: [MS_AccessPros] RE: HOW TO

Kamis, 23 Mei 2013

RE: [MS_AccessPros] RE: HOW TO - Hiding Form if NO Data

Hello John,

First, please accept my apology if I violated the rules "I'm so sorry"

Thank you for the solution, it works as intended.

zjubias

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Friday, May 24, 2013 12:05 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: HOW TO - Hiding Form if NO Data

zjubias-

You cannot include attachments or embedded images on this forum, but I get
the idea. You could try this in the outer form's Current event:

If Me.NameOfSubformControl.Form.Recordset.RecordCount = 0 Then
Me.NameOfSubformControl.Visible = False
Else
Me.NameOfSubformControl.Visible = True
End If

Note that you will have to substitute the real name of your subform.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of ZJUbias
Sent: Thursday, May 23, 2013 3:26 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] RE: HOW TO - Hiding Form if NO Data

Dear All,

I have a form that I put in another form to show record(s) if there is
record in it. This form is a continuous form and recordsource is based on a
query.

I want to hide this form (see below image) if there is no record.

Can someone please show me how to do it..

Thank you in advance

Zjubias

Message Form.bmp

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]