[AccessD] Syntaxes for docmform

Stuart McLachlan stuart at lexacorp.com.pg
Thu Jul 29 02:17:43 CDT 2021

If it's just standard then:
Docmd.OpenForm "frmMyFormName"

If you want to open the form in Datasheet view:
Docmd.OpenForm "frmMyFormName",acViewDS

If You want to apply a filter to the form's recorset
Docmd.OpenForm "frmMyFormName",,,strFilter

If you want it to be read only or open in "Add" mode
Docmd.OpenForm "frmMyFormName",,,acFormReadOnly

If you want it to be modal then
Docmd.OpenForm "frmMyFormName", , , , , acDialog

If you want to pass some argument(s) to the form when it opens:
Docmd.OpenForm "frmMyFormName", , , , , , strArgs

Or any combination of the above. :)

On 29 Jul 2021 at 2:54, Arthur Fuller wrote:

> Could you please give me an example. Of a fully qualified  call to do
> my.openform? -- AccessD mailing list AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd Website:
> http://www.databaseadvisors.com

More information about the AccessD mailing list