The lookup query could look like
quote:
SELECT ID FROM Tabel1 WHERE ID!=42
Where 42 would need to be replaced by the current row's ID. The trouble is, how do you get data from the current row? If there is a way to get data from the current row, it would need to be an Access specific syntax as this kind of thing doesn't apply to standard SQL.
Another issue that you might run in to is, even if you do get the items to show up in the list, when you select an item it doesn't put anything in the box. (At least not in my tests using a standard select everything query)
Is it possible to use a Form for data input?
/ 
