ACCESS FEED: Re: [MS_AccessPros] Change Visible propery of control on parent form.

Rabu, 31 Oktober 2012

Re: [MS_AccessPros] Change Visible propery of control on parent form.

Doyce-

No need for the If Me.Dirty test - I think that will return False all the
time because you can Cancel the Dirty event. Just do:

Me.Parent.btnSave.Visible = True

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: dnwinberry <winberry.doyce@roadsysinc.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Wednesday, October 31, 2012 6:11 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Change Visible propery of control on parent form.

Hello Friends!
I'm trying to make a button visible on a parent form whenever the sub form
gets dirty. In the sub form's dirty event I have the following code that
is not working:
If Me.Dirty Then
Forms!frmCitySemiInquiry!btnSave.Visible = True
End If

The parent form is frmCitySemiInquiry. The sub form is [TagDates Subform]

Seems simple enough but I just can't get this to work.

Doyce

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

Yahoo! Groups Links