In MS Access 2016, the tbl01 has three fields: std_Id, stdnomb and std_nota. I have a form based on tbl01 and it has txtid, txtname and txtnota. I have been trying to write a code for the following: Al is To write a value in the txtid, the code must show the associated values in the txtname and the txtnota (see attached image).
In a preliminary way, I've tried this code, but, it does not work:
Option Compare Database Option Explicit Sub txtid_AfterUpdate() Me.txtid.Value = Me.txtnombre Me.txtid.Value = Me.txtnota End Sub