I'm having one of those extremely nerdy moments where I'm working on a project and test out a form and see something I don't expect to see and all of a sudden - mind blown. Even the littlest things sometimes.

I was doing something I've done dozens of times - building a single form with a button to switch it to datasheet view. I was working in VBA to adjust the formatting, etc. of the datasheet and switching back and forth to make sure everything looked and worked as I expected.

Then, all of a sudden, I see something that shouldn't be there in datasheet view or at least something I never thought would be there:  A "+" appears next to the rows in the datasheet.

Now mind you, I've built datasheet forms with sub-datasheets so I knew immediately what it was (or what I thought it was), however, this particular table has no sub data sheets attached.

So, after making a backup of the form just to make sure it doesn't explode on me or something, I click the "+" to see what shows up. Low and behold, it's an in-line subform. Obviously this was the first time I've every used the single-to-datasheet form method when the single form had a subform in the detail section, lol.

I know for people who have been building databases in Access for decades, it's no big deal, but now that I've seen it, it's pretty handy... You can't put an inline subform in a continuous form, but you can in a datasheet, lol.