[AccessD] subform close ...solved

Max Wanadoo max.wanadoo at gmail.com
Wed Jan 21 16:03:18 CST 2009


William,
I don't think you don't need the docmd.close line.
Also, if you use me.parent you cannot be absolutely sure that it is pointing
to where you *think* it is (see JC's comment earlier).  I would suggest you
use the structure when the main form is named.

Args can be *stored* and then read from the main form be subforms (or use
global vars), or use a text file or use a table (access uses tables)

Max


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

..just to finalize this thread, the following code works totally from within

the subform ...don't have to move focus or use the host ...click on the cmd 
button and the first line works to cleanup the subform itself ...then the 
second line removes the form from the parent subform control and replaces it

with my "big ugly blank" ...or anything you want

Private Sub cmdClose_Click()
On Error GoTo Err_cmdClose_Click


    DoCmd.Close acForm, "frm_SystemColors_sub", acSaveNo
    Me.Parent!Switchboard_Subform.SourceObject = "frm_Main_sub"

Exit_cmdClose_Click:
    Exit Sub

Err_cmdClose_Click:
    MsgBox Err.Description
    Resume Exit_cmdClose_Click

End Sub

...next is figuring out how to pass openargs from subform to subform when 
necessary.

...thanks to all who responded.


William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Wednesday, January 21, 2009 2:11 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] subform close

> 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
>
> -- 
> 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