I have a form that is used for input. All my tables (the ones in question anyways) are 1:1 linked by [BWA_ID]. The problem I am having is too many fields error. I have decided to break the input down into a few subforms. My desired result is something like this:
The problem I am having is dealing with the active record. All the subforms are independant of the main form. If I use the record navigation on the main form, it changes the record on the main form and not on any on the subforms. I was wondering how I could tie these in to operate as one giant form?
Code:
Main Form Sub Form 1 Sub Form 2 Sub Form 3 ect.
Comment