[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