Check Boxes

[jordanturner]

Hi all,



I am creating a stock control database and I would like to put check boxes on the employee form for when a member of staff has left the company and also on the stock form for when an item is discontinued.

I would like these boxes to then update other forms, for example. If a stock item is ticked off as discontinued, then I would like it to no longer appear in the combo box of the purchase order as an 'orderable' item.

The same for staff really, if they are ticked off as no longer working then their name should no longer appear in the combo box on the purchase order form.

Any help or guidance on this issue would be much appreciated.
Thanks Guys

Regards

Jordan Turner

[NTC]

Generally speaking:

1. put the yes/no field into the table

2. in all record sources (queries) for both forms & comboboxes/listboxes - modify the query to include the new yes/no field and set the criteria to be "NO" (assuming that 'yes' means it is discontinued)

Hope this helps you in the right direction.