combo to inactive products

[fabiobarreto10]

gentlemen,
I have a form with three combos. Analyst, company and product.
I'm trying to create a fourth combo to inactive products. That is, the company update the combo, a combo shows the products and another shows inactive products.
How do I create a button on the form to send the active product to inactive products.

 

[Alansidman]

Why not use a checkbox to indicate inactive products. You could then run a query using the checkbox field as the criteria for active or inactive.

Alan

 

[fabiobarreto10]

Alan, thank you for responding. Perfect your idea. I will create a field yes and no.
But the form I would like to create a button. When the user clicks a message box appears to confirm that he wants encerrrar the product. You think it's possible?
I do not know how to make the fourth combo for the closed products.
Again, thank you.