How to Open Continuous Form as Dialog?

[MNF]

I have a form with Default View='Continuous Form', and I want to open
it as dialog,ie
DoCmd.OpenForm "MyForm", , , sFilter, , acDialog
but it opens in "Single Form" mode.
The only workaround I found is to create parent dialog and put my
'Continuous Form' as subform. I am not like this approach, because I
have to create 2 forms instead of 1 for each 'Continuous Form'.

Does anyone knows better solution?

Thanks,
Michael Freidgeim

 

[Allen Browne]

What version of Access is that?

Access 2003 opens MyForm in dialog mode in whatever view is the default
with:
DoCmd.OpenForm "MyForm", WindowMode:=acDialog

 

[Michael Freidgeim]

In a month time I've opened another 'Continuous Form' as Dialog, and it works fine
I returned to the previous form, that didn't work last time, but it works now as well
It's mistery, because I've spent several hours trying to find workaround and it din't work that time.

By the way, I am using Access 2002(XP)

Michael Freidgei
----- MNF wrote: ----

I have a form with Default View='Continuous Form', and I want to ope
it as dialog,i
DoCmd.OpenForm "MyForm", , , sFilter, , acDialo
but it opens in "Single Form" mode
The only workaround I found is to create parent dialog and put m
'Continuous Form' as subform. I am not like this approach, because
have to create 2 forms instead of 1 for each 'Continuous Form'

Does anyone knows better solution

Thanks
Michael Freidgei