William Benson
vbacreations at gmail.com
Thu Sep 8 20:16:00 CDT 2011
I like that concept. Any downside you're hiding from us? ;) On Sep 8, 2011 9:06 PM, "Dan Waters" <df.waters at comcast.net> wrote: > I haven't completely read each post so maybe this has already been brought > up. > > On your form, create a subform. Now create a form to use in that subform, > with all the controls from one of your 'layers'. Then create (start by > copying?) all the forms (as layers) that you'll want to use in the subform. > In your main form, write code to change the SourceObject property to the > name of whichever form you want to display depending on what your user needs > to do. You might want to use Application.Echo False/True in code to > surround the switch from one form to the other to minimize screen flashing. > > This separates out each group of controls onto its own easily editable > separate form, and gives your user a clean GUI which doesn't have the tabs > of a tab control. I have used this and it works fine. > > You can so the same thing with a subreport control on a report. > > HTH, > Dan > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com