[AccessD] subform close

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