make a vba filter works on subform opening

[laghetto]

Hi,
i have a form with a text box that works as a filter by vba code (on click or on change)
the box has a preset value.
i need that when the form is open the filter shows record that have that value.

is it possible?

best regards
PS i don'k know vba!

[geekgirlau]

In the form's OnOpen action, use the same code as you have for the text box