Form display different than expected

[alibachani]

I am creating forms using a wizard in ms access (2002) and they display
fine when I double click on them directly. But if I have another form
execute/run them, the display is changed from lookin like an excel
input method to a record-per-view method. Any suggestions?

 

[fredg]

I am creating forms using a wizard in ms access (2002) and they display
fine when I double click on them directly. But if I have another form
execute/run them, the display is changed from lookin like an excel
input method to a record-per-view method. Any suggestions?

You are trying to display the form in Datasheet View.
If you open a form from an event on another form, regardless of the
form's Default View setting, you MUST explicitly open the form in
datasheet view.

DoCmd.OpenForm "FormName", acFormDS

 

[Guest]

If you are using VBA to open the form:
Docmd.OpenForm "SomeForm", acFormDS
If you are using a Macro, set the View to Datasheet

 

[alibachani]

Thanks!

You are trying to display the form in Datasheet View.
If you open a form from an event on another form, regardless of the
form's Default View setting, you MUST explicitly open the form in
datasheet view.

DoCmd.OpenForm "FormName", acFormDS