Subform Filteron Property Triggers Current Events For Parent Subforms

[jcarroll]

Version: Access 2000<br><br>Hi guys,<br><br>I am having trouble when setting the filteron on property for a subform which I'll now refer to as sfm1.&nbsp;&nbsp;sfm1 shares a main form with two other subforms.&nbsp;&nbsp;Basically how it is set to work is that I have a list box with which I jump between showing all records in sfm1 or just the filtered records.&nbsp;&nbsp;When the user selects to show filtered records in the listbox, I set the filteron property to true for sfm1.&nbsp;&nbsp;Likewise when the user selects to see all records from the listbox, I set the filteron property to false.&nbsp;&nbsp;<br><br>My problem is that when I set the filteron property to true, it also triggers the current events for the two other subforms on my main form.<br>This is a problem because navigating between records in one of the other subforms actually affects the filter on sfm1. Is setting the filteron property for a subform supposed to trigger the current events for other subforms who share a main form with it?<br><br>As always, any help is greatly appreciated,<br>Justin

 

[Robertd]

Hi Justin,<br><br>are you using a refresh method?? or recalc method this will re-triger an on current event..<br><br>see ya<br>Robert

 

[Robertd]

Hi Justin,<br><br>are you using a refresh method?? or recalc method this will re-triger an on current event..<br><br>see ya<br>Robert