D
Donna
In Access 2002 [Inventory Control]. How can I delete and
prevent duplicate product names from the dropdown menu?
prevent duplicate product names from the dropdown menu?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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?
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?
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
Donna said:In Access 2002 [Inventory Control]. How can I delete and
prevent duplicate product names from the dropdown menu?