[AccessD] Syntaxes for docmform

Bill Benson bensonforums at gmail.com
Thu Jul 29 06:26:20 CDT 2021


Stuart, you have shown the datamode cFormReadOnly in the WhereCondition
position.

Arthur the OpenForm’s docs:

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openform


On Thu, Jul 29, 2021 at 3:18 AM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> 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
> >
>
>
> --
> 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