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

  • Thread starter Thread starter Repent
  • Start date Start date
R

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
 
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
 
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
Click to expand...

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!
 
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
Click to expand...
 
Back
Top