Thank you for the additional information. I have checked and there are no
filters being applied, as was the same in my initial post. I also have made
sure that the form was not set to Data Entry only mode, and it was not. This
is a medical entry database and between the 7 tables, there are 12 patient
entries. Not every field has an entry in it in every table though, so I have
made sure that there can be a null value for each field. When I go to the
Form view which displays all of the tables, I can only scroll through 7 of
them instead of the 12 that have been entered. Each record was entered in
Form mode and not in the table mode for each table. Please advise.
It sounds like your form is based on a query. Open that query in
design. You have joins to other tables in that query. Are some of
the join lines missing arrowheads on the ends? These are called Inner
joins. An inner join will only include records where there is a
matching value on BOTH sides. I'm thinking the records you are seeing
have the matching values, but the ones you are missing do not.
So, you could change those joins so that they have an arrowhead
pointing away from the main Patient table. This is an Outer join, and
will include the Patient record even when there is no matching value
in the other table.
But wait. This brings up another question. Are these other tables
lookup values for your Patient table? Normally on a data entry form
you shouldn't include joins to lookup tables. Instead, comboboxes or
listboxes can show the related values, and your form's recordsource
can include only the Patient table. See if you can simply remove
those other tables.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com