I am working Access 2016 and am a novice at visual basic. I am working on a database which has two tables, Patients and Visits. I want to be able to populate a form by using the Patients name, address, post Code to the form which will be saved in the visit Table. I do not have a common key other than the standard ID key. On the form I have fields which match the Patients Table and addition fields which will be filled in by the operator, like date of appointment, means of transport etc. The question is do I need code to transfer the information from the patient table to the visit table form and can I use a combo box to select the information to be transferred. Thanks for your help.
