Re: Combo Box Progressive Requery

use an outer join.
Say the datasource for the subform is tblSub
Also the rowsource for the combobox is something like
SELECT fieldA
FROM tblX
ORDER BY fieldA;

so you just change it a little...
SELECT fieldA
FROM tblX LEFT JOIN tblSub ON tblX.FieldA=tblSub.FieldA
WHERE tblSub.FieldA=NULL
ORDER BY fieldA

.

Relevant Pages

  • ComboBox Progressive Requery
    ... FieldA and FieldB ... > Say the datasource for the subform is tblSub ... Aim is to prevent user from selecting the same combo list item more than ...
    (comp.databases.ms-access)
  • Re: Combo Box Progressive Requery
    ... tblSub.FieldA is one field of a two field key for ... FieldA and FieldB ... > Say the datasource for the subform is tblSub ...
    (comp.databases.ms-access)
  • Re: Compare 2 table & show detail both table
    ... If you've used an Outer join then you should be ok. ... duplicate values in fieldA you can get multiple matches. ...
    (microsoft.public.access.queries)