diamondDog
New member
- Local time
- Today, 02:59
- Joined
- Sep 18, 2024
- Messages
- 26
Oh wow, it works beautifully! Top-notch job!! Thank you!!here is the fix. see the code behind the Main form.
also i added Index (Unique) on MainTbl on Account field.
same on SubTbl, but the index this time is not Unique.
also added Relationship between these tables.
Does the table relationship improve performance speed?
You have already done so much to help me, but since you are very familiar with your code, might I trouble you for a functional and aesthetic addition?
I wanted the subform within my main form's header because I was hoping that the header might increase its height based on the current subform size (which it does, actually) and that it would also shrink again to wrap nicely around each record's subform row count (while also maybe always maintaining a handful of twips between the bottom of the viewable subform and the header).
Would this be possible so that there won't be a header gap preceding the Details portion of the main form for each main-form record?
Thanks again! May your code help countless folks who stumble on it!