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

  • Thread starter Thread starter Peter
  • Start date Start date
P

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
 
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
Click to expand...

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
 
Back
Top