tansfer data from one table to another

[jarry]

I have two table 1 employeeies 2transfer 3employies family
I want when anyone of my employee transfer from my company to other I click the button and give a date of tansfer and all data of employee transfer to transfer table and all family of employee become disable.

 

[CJ_London]

you cannot disable records in a table. You can set flags and use code in a form to disable. Rather than moving a departing employee for one table to another, just set the date of transfer in a field in the employees table. This is your flag to disable.

I assume your employee form has a subform for family so the code in the form current event would be something like

familysubformname.enabled=not isnull(transferdate)