mark record inactive

[rubberhead10]

I would like to be able to set a record as inactive and not have it dispayed in the form. I have an employee database and if an employee is terminated I want to keep the record in the table but not have it dispalyed in the form. I am using access 2007........thanks for your help

 

[TheAceMan1]

How are ya rubberhead10 . . .

Easiest thing I can think of is include a [blue]checkbox[/blue] in the table for this, and make sure its included in the [blue]RecordSource[/blue] and on the form.

The [blue]RecordSource[/blue] should be a query that excludes any records where the checkbox = true!

[blue]Your Thoughts? . . . [/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[rubberhead10]

thanks.....sounds simple enough.....I guess I could not see the forest for the trees..........Happens sometines