[AccessD] subform close

Max Wanadoo max.wanadoo at gmail.com
Wed Jan 21 13:11:10 CST 2009


Or just load it directly with this....

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

Max


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

JC/max

...thanks ...that works for now ...I was close but my syntax wasn't getting 
it done.
...as for the "big ugly blank" concern I have a default form that 
automatically loads whenever the subform control is empty.

William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Wednesday, January 21, 2009 12:49 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [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
>
> -- 
> 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




More information about the AccessD mailing list