What am I missing

[FoodBank]

I know that this should be possible, just seem to be missing something.



Have table with an 'ID number" that is used in a drop down list to add "ID number" to that table.

With a few hundred Numbers it would be nice to remove the "ID number" that have been Entried.



Table 1

"ID number", Data+



Table 2

"ID number", Date, Data+

 

[Jerry Whittle]

Need more information. Are you talking about not showing ID numbers in the
combo box that have already been used in the table? If so, where do these ID
numbers come from? Is there a table of just ID numbers? Some code that
generates the ID numbers?

 

[Designing-Systems.com]

hi,
use a query to populate the combo box. The query should exclude the items
that are already included in the other table.

Say you have two tables, and table 1 is adding records to table 2 and you
need to show only those records from table 1 that have not yet been added to
the table 2. The query to do so is:

SELECT Table1.Field1
FROM Table1
WHERE (((Table1.Field1) Not In (SELECT Field1
FROM Table2)));

Regards,