Bill Benson
bensonforums at gmail.com
Fri Jun 13 09:47:50 CDT 2014
I have also seen this simple command to work, just before changing the sourceobject. If, that is, if you are willing to let everything on the parent form be saved frequently. DoCmd.RunCommand acCmdSave On Jun 12, 2014 1:45 AM, "Bill Benson" <bensonforums at gmail.com> wrote: > My bad in the verbiage (code is fine...) the problem subform is wanting to > show up in Form View (Single)... even though I have set it to open in > Datasheet View, making the latter the default view and setting Allow Form > View = False... I am not sure how to get it forced to datasheet view, I > tried > > X.SetFocus > DoCmd.RunCommand acCmdSubformDatasheet > > And that did not change it. > > :( > >