Stuart McLachlan
stuart at lexacorp.com.pg
Wed Nov 19 16:06:44 CST 2014
One other "wrinkle" if you haven't done it already: I start with an unbound form and place a narrow continuous form on the left hand side with basic info such as the persons name - in your case it may be the naimal ID. Then I put the tab control beside it with all the appropriate sub forms on various pages. I create a hidden text control on the main unbound form with a ControlSource something like: =[frmEmployeeList].[Form]![EmployeePK] Then I put that control's name in the "Link Master Fields" of the subforms. That way users can see/sort/filter a list of the subjects and click on any one to see all of that subject's info. -- Stuart On 19 Nov 2014 at 12:59, Susan Harkins wrote: > Charlotte, it's working nicely and what's really nice about the whole > arrangement is that I can easily add more pages and quickly drop a > subform. I kind of see that happening. :) > > Thanks for the direction everyone -- it's a good choice. And you're > all right -- it was amazingly fast and simple. > > Susan H. > > On Wed, Nov 19, 2014 at 12:22 PM, Charlotte Foust > <charlotte.foust at gmail.com > wrote: > > > Susan, > > > > There are lots of tricks to keeping subforms in sync on tabs, and it > > simplifies the whole process rather than complicating it. You can > > present a clean, intuitive interface where the use can see the > > categories available to them and quickly find what they're looking > > for without being overloaded with information at any one time. All > > the parent form needs to do is hold the primary keys you need to > > link the subforms. Your queries for the subforms are simplified > > because they don't need to include multiple tables to get the right > > records. > > > > Charlotte > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >