Since the txtName data is in the patients' table and not in the appointment table which is the initial table, you have to set the txtName Properties ControlSource to patient.pname.

Hope this help