Datasheet view

[DSJ]

Hi all,
I've created three forms. Main, Summary, Detail. The main form is simply a
meny type form that allows me navigation to the other forms. Summary is to
view data triggered by a query within the main form and summary is to edit
and view the result of the query.

In the SUMMARY page I want the view to be DATASHEET allwoing for the subform
DETAIL to be called in.

So here is my problem if I run the SUMMARY form directly from the form
screen it runs fine. However when I run it through the main form it takes on
another view. Can a DATASHEET view be seen when the form is called in by
another form? Any help would be appreciated.

 

[fredg]

Hi all,
I've created three forms. Main, Summary, Detail. The main form is simply a
meny type form that allows me navigation to the other forms. Summary is to
view data triggered by a query within the main form and summary is to edit
and view the result of the query.

In the SUMMARY page I want the view to be DATASHEET allwoing for the subform
DETAIL to be called in.

So here is my problem if I run the SUMMARY form directly from the form
screen it runs fine. However when I run it through the main form it takes on
another view. Can a DATASHEET view be seen when the form is called in by
another form? Any help would be appreciated.

Regardless of the form's default view, if you open the form using code
from another form you MUST specify datasheet view.

Code whatever button's click event:
DoCmd.OpenForm "FormName", acFormDS

 

[DSJ]

fredg - YOU ARE THE MAN! thanks for your help works perfect.