How do I set form visible from another form

If I close and reopen the form I lose its changes even if I set acSave
to yes when closing.

So I'm trying to keep the form open throughout but making it visible
only when necessary.

So how can I set the visible property from code in the calling form?

thanks, --thelma
Thelma Lubkin [ Fr, 11 Januar 2008 19:13 ] [ ID #1905413 ]

Re: How do I set form visible from another form

On 11 Jan 2008 18:13:19 GMT, Thelma Roslyn Lubkin wrote:

> If I close and reopen the form I lose its changes even if I set acSave
> to yes when closing.
>
> So I'm trying to keep the form open throughout but making it visible
> only when necessary.
>
> So how can I set the visible property from code in the calling form?
>
> thanks, --thelma

Forms!FormName.Visible = false
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
fredg [ Fr, 11 Januar 2008 20:50 ] [ ID #1905418 ]

Re: How do I set form visible from another form

fredg <fgutkind [at] example.invalid> wrote:
: On 11 Jan 2008 18:13:19 GMT, Thelma Roslyn Lubkin wrote:

:> If I close and reopen the form I lose its changes even if I set acSave
:> to yes when closing.
:>
:> So I'm trying to keep the form open throughout but making it visible
:> only when necessary.
:>
:> So how can I set the visible property from code in the calling form?
:>
:> thanks, --thelma

: Forms!FormName.Visible = false
: --

Then I must have another problem. This hasn't been working for
me. The name has no spaces, but it has some capitalization.
If I type it with incorrect capitalization I don't get the
autocorrect version. But when I put that same name in quotes and
use it in a docmd.openform statement, it has no trouble opening it.
--thelma

: Fred
: Please respond only to this newsgroup.
: I do not reply to personal e-mail
Thelma Lubkin [ Fr, 11 Januar 2008 21:07 ] [ ID #1905421 ]
Datenbanken » comp.databases.ms-access » How do I set form visible from another form

Vorheriges Thema: Refreshing Form After Sorting Records - NOT WORKING
Nächstes Thema: Group tables in a pivot