Drop down menu

D

Donna

In Access 2002 [Inventory Control]. How can I delete and
prevent duplicate product names from the dropdown menu?
 
R

Rick B

It depends on what your drop-down is based on. If it is pulling values from
a table, just set up the table to not allow duplicate values.

Rick B


In Access 2002 [Inventory Control]. How can I delete and
prevent duplicate product names from the dropdown menu?
 
R

Rick B

You could also put something like the following in the source if you want to
pull all the unique values from a table of transactions, for example...


SELECT DISTINCT [InventoryTransactions].[ProductName] FROM
InventoryTransactions ORDER BY [InventoryTransactions].[ProductName];



Rick B



In Access 2002 [Inventory Control]. How can I delete and
prevent duplicate product names from the dropdown menu?
 
Top