Making records inactive

[matrix1405]

I need to be able to have all fields in a record to be "inactive" once a date is put into a field. So that when I pull reports that those records are not included in my database anymore. Can anyone help?

[missinglinq]

To do this kind of thing you need to base your form or report on a Query that is based on your table or tables. In point of fact, all forms/reports should be based on queries. If yours isn't, goto Queries and select Create Query in Design View. Select the table(s) your form is based on and include those fields needed in your form/report. If you already have a query, goto Queries and into Design View and in the Criteria for your date field enter Is Null.

If your report/form was based directly on the table go into Design View for the appropriate one and change the RecordSource from the table to the Query. If it is already based on a Query, do nothing.

Now when you run a form/report based on the Query, records that have a date in the field will be excluded.

If you wish to have a form/report that only shows "inactive" records, create an identical Query with the Criteria being Not Is Null.

Welcome to TheScripts!

Linq ;0)>