What is the best option?

[snortby]

Currently the user clicks a button which takes him to another form
displaying the next arrangement. The arrangements are unlimited but
majority of users only have 1 or 2.

I want to display a subform or other type of object on my main form, based
on a recordset which changes with each record on the main form.

In example:
Main form displays demographic data (one record only)
Subform displays children's data (if they have 4 children, 4 "tabs" or other
objects would
appear when the subform opens). When you go to another record who has 3
children, 3 tabs/whatever object would appear when the subform opens.

What is my best bet to keep the information organized on the form while
still displaying enough that they don't have to jump to another area, or
maybe they are looking for the impossible?
Hope I have explained this well?!

 

[Arvin Meyer]

The most sensible way to do what you want is to have all the tabs
pre-designed and hide the unused ones. It would be inconvenient to design a
form with enough tabs for all possible children. Suppose there were a
dozen? Instead use a subform in single form view to display the children's
records. If you need to display their names so that they can be chosen
without scrolling through them, use a listbox on the main form (or in the
subform's header) to display them, and use a click event on that listbox to
navigate to the record you want.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[snortby]

Thank you so much. I will give it a try.

The most sensible way to do what you want is to have all the tabs
pre-designed and hide the unused ones. It would be inconvenient to design a
form with enough tabs for all possible children. Suppose there were a
dozen? Instead use a subform in single form view to display the children's
records. If you need to display their names so that they can be chosen
without scrolling through them, use a listbox on the main form (or in the
subform's header) to display them, and use a click event on that listbox to
navigate to the record you want.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access