Event for filtering based on sub-datasheet record (1 Viewer)

[Kayleigh]

Hi,
I would like to filter a listbox based on the record selected in a sub-datasheet in the same form. However I am not certain which event would be best for this?
I could program it on the click event on a few fields in the datasheet but wondering if there is any more efficient ways would work?

 

[bastanu]

Why not try to do it in the Current event of the subform using the Parent object?

 

[Kayleigh]

Okay but if I wish to clear the filter with a command button, it would probably interfere?

 

[bastanu]

To clear the filter you could use the double click event of the listbox itself.

Cheers,

 

[Pat Hartman]

I'm confused by your structure. Is the listbox on the subform?
Is the listbox an unbound control on the parent form?

 

[conception_native_0123]

To clear the filter you could use the double click event of the listbox itself.

Cheers,

You can use almost all events for this. I think what you want to do is just fine krayna. Furthermore, I think your question is more or less splitting hairs when you don't need to

 

[bastanu]

Of course you can use " almost all events" but the double-click doesn't trigger by mistake as often as most....

 

[conception_native_0123]

Of course you can use " almost all events" but the double-click doesn't trigger by mistake as often as most....

I don't think I've ever had an event ever misfire.

 

[bastanu]

??? of course YOU didn't, but most of us mortals did....

 

[arnelgp]

you can actually do it, if you make the "sub-datasheet" as subform (ds subform).
see this demo.

 

[Kayleigh]

Sorry @arnelgp that sample filter doesn't seem to be working for me.
I think I have a very similar layout to yours. thanks

 

[arnelgp]

i re-opened it and there is error?
i fixed it. you click on "+" to open the subdatasheet, then
you browse the subdatasheet, you will see that the listbox
is filtering.

 

[Kayleigh]

I see now but can this be done without a sub-datasheet ie on the main subform?

 

[conception_native_0123]

but most of us mortals did....

I'm immortal? thanks for telling me! I was unaware.