Yes, it works fine on the on open.
I've also considered using a continuous subform with a main form.
I want to simulate the splir form with the datasheet on the left and the single form on the right.
This is my DVD movie database with a lookup table for the movie genres. Currently I'm filtering the movies using a combo box populated with the lookup table.
Ideally though, I'd like to have a treeview control to have my movie genres in the main nodes and the movie titles assigned to each genre below.
But I believe that is way out of my league. I wouldn't even know where to start.