Forum Discussion
Vertical Split Form?
Hi,
Go to design view of your split form and in its property sheet (on the Format tab) search for Split Form Orientation where you can choose where the datasheet appears, which includes left and right.
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon
A split form displays the same fields from the same recordsource in both the single view panel and the datasheet panel.
What you describe is a 1:M relationship, which means two tables, not one. And that means a split form may not be the most useful approach.
I wonder if Arnel's method, using a main form with subform, isn't the more useful design for 1:M data. To use your pseudo-example, the one side is the table of US State codes in a main form, and the many side is the table of volunteers in a sub form.
- Yeah, it's 1:M. I failed to explicitly state that the volunteer records are on a subform in the main part of the form. Now I need to figure out how to do both a 1:M:1 and a 1:M:M form.
