Need advice on form design 1

[48Highlander]

I am designing a form with some of the fields from each record in a continuous form format at the top. At the bottom will be displayed many of the remaining fields from the record selected on the top part of the form. I think I have three choices:

1. make the main form a continuous form and in the report footer show the remaining fields from the current record
2. make the top part a (continuous) sub-form with the remaining fields showing below the sub-form or
3. make the main form a continuous form and have a sub-form in the report footer.

What is the best approach or am I making this more complicated than it need be?

Bill J

 

[dhookom]

Can you use a list box at the top rather than a continuous form? I would probably use either a list box and single subform or continuous and single subforms.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Not sure if there is a "best" choice.
I prefer an unbound main form, continous subform, and a single form subform. The single form view is linked to the continous form. On the main form I put my control buttons. Here is an example of multiple continous subforms and single form on a unbound main form.

http://www.4shared.com/file/176969705/ae98198/SubForms.html