Access 2000 Question

[FooKilla]

I have a Access database that lists inventory. I want to make it so that if a item needs to be destroyed a person can select "YES/NO" from a drop down box. If "YES" is selected a button will be unlocked that will (when clicked) display a report form with information on the specifc item for a hard copy. How can this be done?

 

[EagleKeeper]

You will need to write some code in either VBA (stored ith the DB) or a seperate app to handle the form display and report generation.

 

[mugs]

In the click event handler for the checkbox, set commandbutton.Enabled = checbox.Checked. I think that's right.