- Local time
- Today, 11:08
- Joined
- Feb 19, 2002
- Messages
- 47,102
I lost track of where this thread is going so I'm just going to point out that the code I posted was not pseudo code. It was copied from an application and not modified. Therefore, if you understand the concept, you should be able to just substitute your variable names.
The code handles THREE levels of a structure. You only need two so you need the top part and the bottom part. I left the middle in because that ties things together and gives you the methodology for copying a structure of any number of levels. You have a Top, and a Bottom. then you have as many middles as you need that are nested with the "bottom" being part of the deepest nested 2. The top works with the record you are viewing on the form, the bottom is always an append query. each "middle" is a vba loop that is nested.
The code handles THREE levels of a structure. You only need two so you need the top part and the bottom part. I left the middle in because that ties things together and gives you the methodology for copying a structure of any number of levels. You have a Top, and a Bottom. then you have as many middles as you need that are nested with the "bottom" being part of the deepest nested 2. The top works with the record you are viewing on the form, the bottom is always an append query. each "middle" is a vba loop that is nested.
