Active/Inactive Option

[mikel]

I have an Inventory database that I am creating and I would like to be able to make an item Active/Inactive instead of just deleting the record. But, in my forms and reports I don't want to see the inactive items.

I add the field to my table, but how do I get the forms and reports to only show Active records?

[Zigzag]

If your reports and forms are based on queries then you would set this up in the criteria or the query.

[mikel]

So the only way is to use a Query as the source for the form and report? Right now the forms and reports use tables as the source. I'll switch it and see how it works. Thanks.

[Zigzag]

Either creat a Query and use this as the record source or click on the ... next to the records source for the form and create the query there.

[mikel]

Ok, that worked.

Is there a way to have the form show all records and then click a button or a check box and then have the form show only active records? Or what if there was a combo box with the option to show all records, only active, and only inactive records. Is there a way to get the form to only show the records based on the combo box result?

[Zigzag]

You could set up an Options Group or Check Box and refrence this in the query. Then add VBA for the Check Box on change event to requery.

me.requery

This would only allow you to show active or inactive but not both.

[mikel]

Sorry, still trying to learn Access. I'm not sure how to do that. Can you offer more specific steps?