ms access - Data filtering on form generates "Could not find field" -

i spent half day trying figure out why appears error messagebox

could not find field 'transactiontypeid'

in database. if open form1, apply filter on column transactiontypeid using header (for instance, uncheck blanks) , try open sorting/filtering second column, appears error message. error disappears if convert combobox text box or remove form select table tenants1. use access 2010 32 bit. in example simplified tables as possible, database created scratch, data imported, compact/repair doesn't help.

do have ideas?

i found problem. built-in datasheet form filtering works in wrong way if tables joined way:

select vouchersmain1.vdate, vouchersmain1.transactiontypeid tenant1 inner join vouchersmain1 on tenant1.tenantid = vouchersmain1.tenantid; 

if reverse tables join direction, built-in filtering works fine:

select vouchersmain1.vdate, vouchersmain1.transactiontypeid vouchersmain1 inner join tenant1 on vouchersmain1.tenantid = tenant1.tenantid; 

looks access bug.

also, @munsterlander, problem disappears if form's recordsource replaced saved query instead of select