If the combobox does not have a ControlSource then it is UNBOUND. If it is used to save value to field and you want to limit its list to values not already associated with a master record, that requires a RowSource query that includes data and lookup tables. Essentially a 'find unmatched' query. Or possibly using NOT IN() function.