Added records in form show up in tables but not on form

[Ebbrecords]

I have a form that consists of 7 different tales. When we add records to the
form, it adds the information to each of the tables, but they do not appear
back in the form. We have 10 different multiple entries in each table, but
they do not appear in the form. Each table may not have every field entry
filled out and that does not seem to be the problem. I also made sure that I
was not applying any filters to the data entered. please help......

 

[Armen Stein]

I have a form that consists of 7 different tales. When we add records to the
form, it adds the information to each of the tables, but they do not appear
back in the form. We have 10 different multiple entries in each table, but
they do not appear in the form. Each table may not have every field entry
filled out and that does not seem to be the problem. I also made sure that I
was not applying any filters to the data entered. please help......

If your form *never* shows existing records you may want to check the
Form properties that it isn't in Data Entry mode. If so, it will only
add new records, never show existing ones.

Otherwise, you must have some other filtering or recordset issue.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Ebbrecords]

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.

 

[Armen Stein]

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