Shattered Rose Studio
San Francisco, CA
James Wj Snyder

RE:  Access style multiple adding to related tables.

Hello peoples,

Having done work in several database programs before moving into VB I found in "interesting" (read annoying) that when I add a new record to the master table, I had to tweak things to add a related record in the secondary table(s).  So enclosed you will find MY work around.  It is not the only way, and maybe not even the best, but it does work.  (That accounts for something)

NOTE:  The database is in Access 2.0 format.  If you only have access 1.x get the compadability layer for VB.  It's in the Office Development Kit from MS  (hey guys, a free plug, and you thought I didn't care) and many other places.  Reguardless, the code should help you out.

The default dirrectory for this program is:
c:\addnew


Peace,
James