Design question

[Seth Schrock]

Okay, I think I'll worry about HOW it work later. I have pasted in your code, Z, (making all the names fit my database) and it is working perfectly. Now all I have to do is follow your example for the reports that I need.

Thanks so very very much Z. I really appreciate all the work you put into creating this sample for me.

[zmbd]

My pleasure.
The recursion is really a pain(...) in this case. One would think that in the afterinsert or afterupdate event that one could cause the record cursor to simply move to the last inserted record... it just doesn't work that way... took me months to figure that out back in the older versions of MSA!

The reports were just simple report wizard based using the two queries... I even used the control wizard to place the two buttons for the reports on the form... not the most elegant code; however for a very basic action it works.