Hiding records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When an employee is terminated, I want to hide their record in my form but
show the rest of the employees. I show them as terminated by using a Tick box
for Yes or No.

Perhaps using the record to update another table and take them out of the
form completely would be good but I have no idea how to do that.
 
When an employee is terminated, I want to hide their record in my form but
show the rest of the employees. I show them as terminated by using a Tick box
for Yes or No.

Perhaps using the record to update another table and take them out of the
form completely would be good but I have no idea how to do that.
Click to expand...

That's not necessary.

Simply base the Form on a Query with a criterion selecting only those
employees who are still on staff (a criterion of No on the Terminated
yes/no field).


John W. Vinson[MVP]
 
Delma

In addition to John's suggestion, you'll probably want to re-query your
form's source after checking an employee's Terminated checkbox (per John's
suggestion). You can do this with something like:

Me.Requery

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top