Re: Form won't display work*** format & it reverts back to single vi

On Tue, 1 Jul 2008 08:38:02 -0700, Peter wrote:

Hi there.

I've developed some forms which show the results of queries. The forms and
the queries both work fine. When I run the form as a stand alone - i.e. open
it or modify the design of the single form - it works fine and shows in
work*** format as designated in the form properties.

However, if I launch the form via a command button from a control / menu
form, it always reverts back to a single form only. The data is all there
because you can see it if you scroll down in the single form field.

I've double checked the form properties and they are set to work*** and
all other form views are set to no.

Does anyone have any idea why it reverts back to a single form when it's
called from the main form?

Thanks in advance

If you open ANY form (regardless of that form's Default Form View
settings) from an code event you MUST specify data*** view.

DoCmd.OpenForm "FormName", acFormDS
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.