Adam, all very interesting! You recordsource for F2_SUB never changes, is that right?
if you look in the property sheet for the subform, you'll notice there's no value in there. if you change the RS in code, that value listed in the prop sheet also never changes, but the subform itself *does* reflect the changes made through code when you view the sub in access's interface.
And you have two Forms. That's differnt from 1 form with a subform. Any significance ? I do see what you're doing (those modules are not part of it?).
see the attached image, Kirk. I don't know what method you used to create your sub:
- dragging and dropping it from the db window object to the main form while its in design view.....OR:
- creating a subform control through the interface's control wizard.
if you did #2, what you will find is that it doesn't matter if you choose *use existing tables or queries* or *use an existing form* as the option for creation....when the creation process is over, an actual form *object* appears before you in the db window.
I have not used Requery, should I ?
per Gasman, it's apparently not needed. I just tend to go overboard making sure things work. It's the same thing as a software platform creator providing developers multiple resources that do the same thing. For instance, I develop a lot in PHP, and it has 2 identical functions in it that do exactly the same thing, which is query out mysql data from server db's. they are:
The Name is only shown in Properties-Other depending on where you click. I always thought you clicked on the square betwteen the 2 rulers.
if you click on the *orange square in the upper left you're talking about, the prop sheet you see will not show *name* on the *other* tab because you're looking at the properties of the actual form object, *not* the subform control.
pretty confusing, eh? That's microsoft for you! those nuances are exactly the reason why I love open-source genius so much. They care a lot about their users, and in general, their stuff works wonderfully! By the way, I would check with the experts around here to make sure everything I've said is really accurate.