How can I check a record to be inactive

[Frank Situmorang]

Hello,

Is there any sample of a database which shows a form that we can select to a
record to be inactive, sample household talbe, there are some housae holds
who are dormat, so I want to inactivate it.

But anyway since I linked house hold address to members table, and I want to
say that I can only inactivate household if all family members is already
with a status of inactive.

Thanks for anyhelp

 

[Arvin Meyer [MVP]]

Hello,

Is there any sample of a database which shows a form that we can select to
a
record to be inactive, sample household talbe, there are some housae holds
who are dormat, so I want to inactivate it.

But anyway since I linked house hold address to members table, and I want
to
say that I can only inactivate household if all family members is already
with a status of inactive.

Add a Boolean (Yes/No) field named Active.

Change the queries that are the recordsource of your forms and reports by
adding to field, and setting the criteria to True, or -1