Please I am directing this post to The Missinglink. In 2005 I posted the above thread and you gave a beautiful reply. But because I am new to Programming I have not been able to implement your solutions.

Please, kindly help me with the codes. You said you use two forms - one for Active patients and the second form for Inactive patients.This is exactly what I want to do in Payroll program I am writing:
I want to have a Database to hold data for all employees. When an empoyee leaves the organisation, instead of deleting his records, I would want to make his records Inactive and transfer his records to a Database for Inactive employees. That means I will have a separate form for Active and Inactive employees just as you have for your patients.

Please kindly sen me the codes you use for your patients.

Thank you in advance.