Excluding items from a table so user cannot see or select them

[Repent]

I have a form with a drop down box that pulls data from a table. the
table is a list of products. not all of the products are currently
available. How can I hide unavailable products from the list without
deleting them form the table? Later on those products might become
available again so I'd like to just hide them fomr the user as
selections.

thanks;
chris

 

[John Spencer MVP]

Add a boolean (yes/no) field to the table named archived and check it to mark
records you want to hide.

In the combobox set the source of the combobox as a query that returns records
as long as they are not checked in the field.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

I have a form with a drop down box that pulls data from a table. the
table is a list of products. not all of the products are currently
available. How can I hide unavailable products from the list without
deleting them form the table? Later on those products might become
available again so I'd like to just hide them fomr the user as
selections.

thanks;
chris

Do you have any way to identify available products based on the value of a
field in the table? If so, base the combo box on a Query rather than directly
on the table, and select only available items.

If you don't have such a field... well, create one. Access can't read your
mind or survey your warehouse!

 

[Repent]

Worked perfectly thank you very much!

chris

Add a boolean (yes/no) field to the table named archived and check it to mark
records you want to hide.

In the combobox set the source of the combobox as a query that returns records
as long as they are not checked in the field.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County