[AccessD] Force a form to open in datasheet mode

Stuart McLachlan stuart at lexacorp.com.pg
Fri Feb 15 17:39:07 CST 2013


The default acViewMode  for the VBA command DoCmd.OpenForm is acNormal.

Try Docmd.OpenForm "frmMyForm",acFormDS

-- 
Stuart  

On 15 Feb 2013 at 18:15, Arthur Fuller wrote:

> I forget how to force a form to open in datasheet mode. The default view is
> already set to datasheet and the other views have all be set to No, but a
> simple call to DoCmd.OpenForm still opens it in Form view.
> 
> This occurs only when I invoke the form from the default switchboard. If I
> just open the form from the Objects pane it opens correctly. What's the
> difference?
> 
> -- 
> Arthur
> Cell: 647.710.1314
> 
> Prediction is difficult, especially of the future.
>   -- Niels Bohr
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list