Setup Split Form

[airboat]

Sorry I'm back again...everyone here has given me such an education in 2 short weeks, but I have another one, this time for the "Form"

We have used the Split Form before but I have a condition a bit different and I don't know if this is possible. I have a table "qry2010MasterTableWithSC" and a table "Sub". What I would like to do is be able to have...On the upper part I want to have the data from Permit and on the bottom I want to have the relating data from a table called sub and they will be connected by a field called SC.
On top will always be one record. On the bottom there will be many subdivisions that match that SC in the table format. I will be looking at the list and making a decision on which one is a match for my record on top from "qry2010..." and giving it an "SB", which I will get from table "Sub" on the bottom.

Bob

 

[MajP]

Bob,
Since I have a pretty good understanding of some of the things you are attempting, give me a better explanation of the big picture. Do not describe a specific interface or solution. What does the desired interface allow you to do?