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

Rabu, 31 Oktober 2012

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

Thanks John! That's perfect.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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@...>
> 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
>