filter form on value from linked table

[greeknl via AccessMonster.com]

Is it possible to filter a form (based on table A) on a value in a table B
where the tables are linked?

Table A
ID
lastname
firstname
companyid
...

Table B
companyid
companyname
...

I would like to filter the form records (Table A) by using as input the
company name (or part of it) from a textbox.

Thank you

 

[greeknl via AccessMonster.com]

Sorry for this but I forgot

I would like to use like
frm.Filter =
as I already use it to filter the form based on values from another txtbox on
the lastname