Delete items from a Combo 2

[Georgews]

I have two tables, one with equipment details such as StockNo, Type, Desc etc and one table with a list of possible StockNos, many of which are unused.

My form is based on an unmatched query which enables me to a) get a list of equipment entered which has not been allocated a stockNo and b) lets me enter new equipment.

I have a combo which then looks at the StockNo table and displays available numbers.

Often I need to enter several new pieces of equipment and I want to combo to show only the unallocated numbers. i.e. as I use a number it is deleted from the combo list as soon as it is entered. Refreshing the form works but this is tedious when having to do it 25 times.

Any clues? Thanks in advance

 

[tomschafer]

Create an On Enter or On Exit event for the combo-box to requery it.

 

[mac318]

You appear to have knowledge of using SQL because you are loading your combo boxes appropriately. Use an SQL DELETE Statement to delete the new number from the combo box's underlying table and requery the combo box. It works rapidly and efficiently.

mac