Searching a Subform

[Gasman]

Hi. I think the ApplyFilter action applies the filter to the current (main) form. Just as a test, try moving the button to the subform and adjust the syntax to remove the reference to the main form.

I've just tried and it wanted a SelectObject action first, but I could still not get it to work, even with the builder. So glad I learnt some VBA.

 

[goilev]

Is frmIngredients the name of the subform control in frmRecipe? Or is it something like Child5?

Yeah it's named correctly.

For anyone Googling this in the future... VBA. Is. The. Way. See theDBguy's post a couple up

 

[Gasman]

FWIW I finally got a macro to work.

From https://stackoverflow.com/questions...-a-subform-in-access-what-is-the-control-name

sfrmemails is the subform control in my main form.

Think I will stick to VBA

 

[theDBguy]

Thanks so much everyone for you help! It really is appreciated on a Saturday night!

@theDBguy your VBA syntax worked a treat.

We beginners are so lucky to have a resource like this forum with such patient and generous members.

Have a wonderful weekend all and please all stay safe!

Hi. You're very welcome. Glad we could assist. Good luck with your project.