jwcolby
jwcolby at colbyconsulting.com
Wed Jan 21 15:30:58 CST 2009
William, What happens if you just remove the first line? John W. Colby www.ColbyConsulting.com William Hindman wrote: > ..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 >> >