Combo Box Duplicates

[DontellTrevell via AccessMonster.com]

When user selects an item in a combo box
that is already selected and stored in a data table. (1) I want the item
ghosted or not visible in the combo box. or (2) Give user a msgbox that
says record has already been selected.

 

[Douglas J. Steele]

What's the RowSource of your combo box? You need to use a query that only
returns those rows that aren't stored in the data table, and requery after
each update of the data table.

 

[DontellTrevell via AccessMonster.com]

The RowSource is: SELECT [tblBTWNumbers].[ID], [tblBTWNumbers].[BTWNumbers]
FROM tblBTWNumbers;

 

[Douglas J. Steele]

So, as recommended, create a query that joins tblBTWNumbers to the data
table and only returns those values in BTWNumbers that don't exist in the
data table.

Something like:

SELECT [tblBTWNumbers].[ID], [tblBTWNumbers].[BTWNumbers]
FROM tblBTWNumbers LEFT JOIN DataTable
ON tblBTWNumbers.ID = DataTable.ID
WHERE DataTable.ID IS NULL


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The RowSource is: SELECT [tblBTWNumbers].[ID],
[tblBTWNumbers].[BTWNumbers]
FROM tblBTWNumbers;

What's the RowSource of your combo box? You need to use a query that only
returns those rows that aren't stored in the data table, and requery after
each update of the data table.