Hi

I have two forms. One is the mainform and the other is the subform.

Main form: Airstrip Profile

Fields in main form: Airstrip_name

Subform: Amo Profile

Fields in subform: Airstrip_Assigned

Airstrip_name and Airstrip_Assigned fields are equal. When I edit a record and based on Airstrip_Name in the mainform, it should fetch the record that matches the name in Airstrip_Name with Airstrip_Assigned in the subform.

Please can someone show me how its done.

Cheers