Originally Posted by
jzwp11
Welcome to the forum!
Are you using subforms in your central entry form? I assume that you did not use subforms. If you base a single form on multiple tables, Access actually binds the form to a query that joins the multiple tables. I assume that for the first four datasets, you entered data such that at least one field in each of the tables had something entered. For the additional datasets, if you did not enter data in at least 1 field from all of the tables then a matching record was not created and thus does not satisfy the joins of the query and thus are not shown when you reopen the form. To avoid this, what is typically done is that you would have a main form with various subforms. The main form would be bound to the primary table which in your case is the patient table. Each subform would then be based on the related tables.
Now, you did not mention much about how your tables are related. At the heart of every successful relational database is the table structure. Before doing any other forms, queries or reports, it is critical that your table structure is correct.
For example, let's say that you work for a doctor's office and that you are tracking patient visits to that office. Most people visit the office more than once. So, a patient has many visits. This describes a one-to-many relationship between the patient and visits. To represent that in forms, you would have a main form based on the patient table with a subform based on a table that holds the info about the various visits.
Let's say for example that you want to track patients' medications. A patient can take several medications. Also, a medication can be taken by many patients. So, you have 2 one-to-many relationships. When you have 2 one-to-many relationships between the same two entities (patients and medications) you have a many-to-many relationship. This is typically handled with 3 tables (patient table, medication table, and a table that joins both patients and their medications: also called a junction table).
Now, to make sure you are on the right track relative to your table structure can you zip & post a copy of your database (with any sensitive data removed) or at least your table structure?
Something similar to this
tblPatients
-pkPatientID primary key, autonumber
-txtFName
-txtLName
tblMedications
-pkMedID primary key, autonumber
-txtMedName
tblPatientMedications
-pkPatientMedID primary key, autonumber
-fkPatientID foreign key relating back to tblPatients
-fkMedID foreign key relating back to tblMedications