How to implement Allen’s mdb sample form filter on a datasheet sub

[Adnan]

I downloaded Allen’s great mdb sample for the kind of the form filter I was
looking for from http://allenbrowne.com/AppFindAsUType.html, it works awesome
but I need this exact kind of search to filter a datasheet subform, any help
on this?

Thank you,
Adnan

 

[Allen Browne]

A datasheet can't show the form header or footer where you would put these
controls.

Could you use a Continuous View subform instead?

 

[Adnan]

Continuous Form does not offer me entire row selection and is limiting me on
some options, etc…

Right, I don’t have to have datasheet’s subForm header or footer shown, but
this datasheet is a subForm (on detail section of the frmMain) and instead I
use frmMain’s header or footer for controls.

We all appreciate your help Allen,

Adnan

 

[Allen Browne]

No: the code looks at the form that contains it.

You cannot use it in a main form to control what's going on in a subform
without doing some heavy modifications.

 

[Adnan]

Alright, I guess I just use Continuous form.

Thanks for your time Allen,
Adn