[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