filter form on value from linked table

  • Thread starter Thread starter greeknl via AccessMonster.com
  • Start date Start date
G

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
 
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
 
Back
Top