MS Access, creating a from that can populate from 2 tables

hi all.
Ok, i'm creating a data-entry form that i need to do the following:

1. When i open the form i want the fields to be empty
2. when i enter a patientID, i want name, DOB etc to auto-populate.
patientID, name, DOB are saved in a table called tblmembers. I have a
combo box setup for patientID that connects to the
tblmembers.
3. I have text fields "clinicalsummary ", "medications" in the from. at every
clinical visit, we need to enter some information. When i enter this
information into the form, i want the completed form to be saved in a
different table called tblforms which will save patientID, dateofvisit,
clinicalsummary, medications
4. Finally, when i open the form and enter a number for someone who has
already been seen by us, i want the information from tblmembers to
autpopulate as usual and then i want the clinicalsummary and medications
from tblforms to autopopulate too.

I'm new to VB so not familiar with codes. Can this be done? I'd really appreciate the help!! On a deadline!

 

If you can't get any help here, try http://www.datapigtechnologies.com/AccessMain.htm

Sven