Hi -
I MUST tell on MYSELF because I thought this was so funny. I am so proud of - and am doing additional work on - my CD database.
Then, starting yesterday and this morning I thought "oh no, now what is wrong with this thing?"
I have 49 CD's entered so far. But as I would work on my forms - and I glanced at the form # - it would change seemingly without any rhyme or reason. Suddenly, instead of being on form 2 of 49, I would be on form 2 of 15 and I thought "oh no, did I lose my records?"
Then I would be on the second form and click on advance to next form and no matter how many times I clicked, I would still be on the second form (even though at the top, it would advance to form 3, 4, etc.). I thought I was going to have to ship another database to Ray to have it checked out.
And then suddenly I burst out laughing. It took me all that time to realize that the "counter" at the top of the form was properly responding to the correct form # and total # of forms DEPENDING on whether I was on the MAIN form or the SUB form.
So, I can now go back to simply enjoying and being very proud of my foist databse with sub-forms. Once again, I am extremely impressed with how simple and easy-to-use this function is. Congratulations, again, on some incredible design work.
On that note, all I can say is: