How can I check a record to be inactive

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

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
 
Frank Situmorang said:
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.
Click to expand...

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
 
Back
Top