Form won't display worksheet format & it reverts back to single vi

[Peter]

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

 

[fredg]

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
worksheet 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 worksheet 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 datasheet view.

DoCmd.OpenForm "FormName", acFormDS