Object invalid or no longer set (AC2007)

[AOB]

Wow, thanks vbaInet, this is a wealth of information

Am supremely grateful for the effort in putting this together, thank you very, very much. Might take me some time to digest it all but just wanted to post a quick thanks lest you thought I was being ignorant - I'm not, quite the opposite, I just want to take some time to properly take all of this in.

ions - thanks for your input - you know what, I did wonder about nesting one of the subforms within the other - I quite like the idea of a hierarchical subform where one could drill down / expand. But I thought you could only do something like that with a TreeView control or something of that ilk. I probably won't do that here but it is definitely something I'd like to be able to do in future projects. Your comment gives me hope that it's possible!

Thanks again everybody, this forum has been absolutely invaluable as always!

 

[vbaInet]

No problem!

You get drill down look by selecting a query or table in the Subdatasheet property of a query or table. It has been known to cause some performance issues in the past. I don't know how they perform now.

 

[ions]

I turn OFF Subdatasheets at the table level for the reason vbaInet mentioned but I have had no issues with implementing Drill Down at the Form level by nesting two Datasheet subforms and linking Parent / Child.

I also don't always use this approach because at times you want to fully control the look of the output which this quick approach doesn't fully allow.

Yes vbaInet contributed very much to this post. It's pretty amazing.

 

[jdraw]

Yes vbaInet contributed very much to this post. It's pretty amazing

.

Yes he has and with over 22,800 posts, he has contributed to many, many posts.

 

[vbaInet]

Only a fair few chaps!