[AccessD] Open a form in DS mode

On 7 Apr 2005 at 19:50, Arthur Fuller wrote:

> >>How can I let this form know that I want to run a given form in 
> >>DataSheet mode? Even though I set its default mode to DS, it doesn't seem
> >>to help.
> >Pass the form name as "ds" & frmMyForm.name(for DataSheet) or "fv" & 
> >frmMyForm.name (for FormView). Then parse OpenArgs for these characters as
> >well.
> Good idea, and fits in with the existing logic. But what do I tell 
> Access to do, given that I find "ds" as the prefix or suffix or whatever?

Select Case left$(OpenArgs,3)
   Case "qry"
        .......
   Case "rpt"
        ......
   Case "dsf"
       docmd.openform mid$(OpenArgs,3),acFormDS
   Case "fvf"
      docmd.openform mid$(OpenArgs,3),acFormNormal
   Case Else
End Select

-- 
Stuart