Form display different than expected

  • Thread starter Thread starter alibachani
  • Start date Start date
A

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

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
 
If you are using VBA to open the form:
Docmd.OpenForm "SomeForm", acFormDS
If you are using a Macro, set the View to Datasheet
 
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
Click to expand...
 
Back
Top