I want that when I enter the vendor name, the CNIC and NTN should automatically update in the subform?

[moin555]

 

[Gasman]

Change Vendor Name to a combo and bring the other data into the combo.
On Afterupdate of the combo, set the other controls to their respective data.

If you want to leave it as a textbox, then use DlookUp() to get your extra data. Be prepared for not finding anything due to keying error.

 

[arnelgp]

try this, add some amount the chkAmount or Tax.

 

[moin555]

i am changing but not updated kindly check i share file with you sir

 

[moin555]

arnelgp sir i want vendor name is subfrom insted main form. when i enterd vendor name cnic and ntn auto update ​

 

[arnelgp]

here test this.

 

[moin555]

thanx sir When I click on the Details ID in the subform of tblVendorRegistration, the tblCompliance with the same ID should open. can itpossible