[AccessD] subform close

This will do what you require William.

[Forms]![MyMainFormName]![MyHostCotainerOnMainFormName].SourceObject = ""

Ie, on my system this translates into

[Forms]![MCM_Peoplemainform]![PeoplePopSub2].SourceObject = ""

I would normally have a series of buttons on the main form and when clicked
the sourceobject is changed to the name of the form I want to appear, but
setting it to "" works even when invoked from the sub form itself.


Max

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: 21 January 2009 17:36
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] subform close

...why does anyone? ...like all programmers I'm a masochist at heart :)

...experimenting with a new gui ...need to work out the kinks :)

...and I'm working on just that approach :)

William

--------------------------------------------------
From: "Gustav Brock" <Gustav at cactus.dk>
Sent: Wednesday, January 21, 2009 4:33 AM
To: <accessd at databaseadvisors.com>
Subject: Re: [AccessD] subform close

> Hi William
>
> Why are you doing this to yourself?
>
> That said, you may have to move the focus off the button as the first 
> thing.
> Then, shouldn't this work? Haven't tried myself though:
>
>  Me.Parent!NameOfSubformControl.Value = strNameOfNewSubform
>
> or
>
>  Me.Parent!NameOfSubformControl.Value = Null
>
> You may need to move the code to the main form and call it from the 
> subform to not let the subform kick the feet of itself away.
>
> /gustav
>
>
>>>> wdhindman at dejpolsystems.com 21-01-2009 08:26 >>>
> ...closes host and sub :(
>
> ...naming the sub instead doesn't change what I see ...the acSaveAll 
> works,
> the form just doesn't disappear from the subform control
>
> ...if I change the mainform subform sourceobject from the host form, the
> form is either replaced by the new sourceobject or the subform goes blank 
> if
> I set it to ""
>
> ...but that leaves me vulnerable to users closing an open subform from the
> host form without a proper close
>
> ...trying to workout the semantics for setting the mainform subform
> sourceobject from the subform ...this should be simple but I'm missing
> something.
>
> William
>
> --------------------------------------------------
> From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
> Sent: Wednesday, January 21, 2009 12:08 AM
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] subform close
>
>> Wait, I see.  I think you have to specify the form name of the host form:
>> DoCmd.Close acForm, ObjectName
>>
>>
>> Rocky Smolin
>> Beach Access Software
>> 858-259-4334
>> www.e-z-mrp.com
>> www.bchacc.com
>>
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William 
>> Hindman
>> Sent: Tuesday, January 20, 2009 8:47 PM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] subform close
>>
>> ...subform hosted on non-linked main form
>>
>> ...command button on subform
>>
>> DoCmd.Close ...button animates but form doesn't close
>>
>> ...thinking that I'm probably going to have to set the mainform subform
>> sourceobject to "" or another object and clean up anything on the open
>> subform such as dirty data before I do it.
>>
>> ...anyone done this and have tested code or suggestions?
>>
>> William
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com