Detect From Main Form When Subform's Source Object Changes

[robs23]

Hi Guys,

actually the whole point of my question is in the title. But of course I'll elaborate for better understanding what I'm trying to achieve.
I have a main form and a subform on it. Subform shows data in datasheet view. I use main form as a kind of navigation panel - I change subform's source object by clicking controls on main form. It works ok.


Now, however, I'd like to find out a way to detect subform's source object change. It'd be best if there is a form/subform event that is triggered in such condition. I know I can detect it with control's events (e.g. button_click) on main form but this IS NOT what I'm looking for.

A help here is appreciated.

Robert

[rpeare]

can you be more specific about 'detect subform's source object change' Are you talking about a control source change, i.e. you force a control source change on your subform with a button click on the main form, then you want to detect when that change is actually complete? or do you have some tools on your subform that also force changes within the subform and you want those events to trigger something on your main form?

[robs23]

Hi rpeare,

Thank you for answer. It's actually a something else. I have a "filter" class in my project. I create an instance of this class on main form's load and kill it on close. This class can handle cotrols' events or main form's events thanks to "WithEvents" method. This maximize code's reusability - I can use this object on many forms and in many projects without much hassle. For example I use object with "WithEvents" to replace Access standard ctrl+F window - the object grasps cotrol_keyDown event and trigger built-in method to place cursor into filter textbox.
Now, it works very good with standard forms. Unfortunately, in my previous project I made a form containing subform, and with main form's buttons I change subform's source cotrol to present different queries. I know it's not the best way but at that time I couldn't do any better and now I don't want to change it. So now I have to find a way to detect when suboform's source object changes and trigger procedure. It has to be handled by "filter" object and due to this it has to be done from main form. The question is: how can I do that? I'll be explicit - I don't want to place any code on subform itself as it would break the reusability.

Robert

[rpeare]

Can you supply a pared down sample of your database with just the tables/forms in question as an example and then explain exactly which event (what buttons/controls/keystrokes) you are hoping to detect the control source change on. When you create your sample database get rid of any confidential items and just put enough data in to simulate the data and problem, then compact/repair the sample database, zip it up and upload it to this site for examination.

[Micron]

Not sure my suggestion will fit, but I had a situation where I had to trap changes in form or subform record. The IsDirty property wasn't working because once a record on the sub was committed, the property was False, so I couldn't detect changes from the main form button events. The solution was to create a higher level variable bolIsDirty that I could check. For me, the declarations section at the top of the main form was sufficient since the button code was on the main form. For you, I'm not sure if on the main form, or as a public variable in a standard module. So, the suggestion is to set a variable that will remain in scope at the point you change the property or value and test it when you need to.