I am not quite sure that my subject line actually describes what I am try to achieve, so I will do my best to describe it here.
I am creating a database to track patient visits to various medical clinics. I have a Contact information form where I can enter (for a new patient) or update (for a returning patient-if required) the contact information for the individual. This form has a field to enter the Patient ID number. This is the PK for the Contact Information table and the FK for all of my other tables in this database.
I then have a form for entering the details of the medical visit. This has a list box for choosing the Patient ID number for the patient. This form also has 13 subforms linked to the underlying tables for storing the visit information. Each subform has various quantities of checkboxes for making selections in various categories (one category for each subform/underlying table).
I would like to have a "New" button that would clear the data in ALL of the subforms in but NOT the Listbox on the main form in preparation for entering information about the patient's visit.
I would also like to have a "Next" and "Prev" button for moving through the records on ALL of the subforms related to the Patient ID selected in the Listbox on the main form. Basically a method for scrolling through all of the visit forms for the selected patient.
It should be noted that the subforms are not popup forms they are designed to look as though they are all part of the main form.
Am I asking to much of Access here or have I gone off in completely the wrong direction? Is there a way I can accomplish what I need with what I have done?
Any help is appreciated.
John V