I ran into the dual problems of Access's habit of growing larger
and larger mdb files and its problem of not being able to "undo" a
form combined with a sub-form.  I wrote a program that handles both
problems and an article describing how it works.  Originally I
intended to sell them to Access/Visual Basic Advisor; however I
haven't been able to get a response from them.  So I am releasing it
to the public for whoever wants it.  Below is the intro to the
article.  If you want to download all the article and the code example
they are on my web page at http://www.*-*-*.com/ ~jridenou  The name
of the file is "UndoGrow.zip".  Download it then unzip it.  Read the
readme.txt file first.
   The code is written in Access 2.0 so it should work in all
versions.

: I ran into the dual problems of Access's habit of growing larger
: and larger mdb files and its problem of not being able to "undo" a
: form combined with a sub-form.  I wrote a program that handles both
: problems and an article describing how it works.  Originally I
: intended to sell them to Access/Visual Basic Advisor; however I
: haven't been able to get a response from them.  So I am releasing it
: to the public for whoever wants it.  Below is the intro to the
: article.  If you want to download all the article and the code
: example they are on my web page at http://www.iwaynet.net/~jridenou
:............................................

Hi Jim,

If you want to get some further exposure for your efforts you should
post the solution at the World Wide Developers Network FTP site.

The Access homepage is at:
http://www.wji.com/access/homepage.html

Look for the jump to Access Downloads / FTP.

This is a very professional and well organised site with monthly
newsletters to members ... have a look when you get some time.

-- Chris Bell --