Hi
First post - thank you in advance for any help you are able to give. I think I need some help with VBA coding.
I work in a hospital and have created a database for patient waiting list forms, I would also like to use this as a patient database. Some patients may be listed on the waiting list 2+ times therefore may have multiple waiting list forms. I intend to make a subform for the "patient details" section of the form as this will be a one to many relationship with the waiting list forms.
Each patient is coded in the hospital by a unique identifying number, is there any way to auto fill the rest of the patient details if they have already been inputted before (i.e. forename, surname, d.o.b., address etc) on the sub form once the unique identifying number has been input?
Thank you so much for any help you are able to give.