D Donna Jun 28, 2004 #1 In Access 2002 [Inventory Control]. How can I delete and prevent duplicate product names from the dropdown menu?
In Access 2002 [Inventory Control]. How can I delete and prevent duplicate product names from the dropdown menu?
R Rick B Jun 28, 2004 #2 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?
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 Jun 28, 2004 #3 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?
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?
O oulijuan Jul 3, 2004 #4 Donna said: In Access 2002 [Inventory Control]. How can I delete and prevent duplicate product names from the dropdown menu? Click to expand...
Donna said: In Access 2002 [Inventory Control]. How can I delete and prevent duplicate product names from the dropdown menu? Click to expand...
