Form will not display records

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

In Access 2007, one of our users has asked me to research the following,
She built one form, using fields from 5 tables, each table has a field,
Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join relates
the 5 tables. She then created the form, using the fields from the tables.
Data entry works perfectly, and the tables get populated, but when closing
the application and then restarting it, the data does not display in the
form, although it is still in the tables.
What could cause this behavior?
 
Thanks for the reply - but Data Entry is set to No.
Any other thoughts will be greatly appreciated.
 
PA said:
In Access 2007, one of our users has asked me to research the following,
She built one form, using fields from 5 tables, each table has a field,
Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join
relates
the 5 tables. She then created the form, using the fields from the
tables.
Data entry works perfectly, and the tables get populated, but when closing
the application and then restarting it, the data does not display in the
form, although it is still in the tables.
What could cause this behavior?
Click to expand...


If her form's recordsource query performs an INNER JOIN among five tables,
every one of those tables must have a matching record in order for the query
to return any data. That means that at least one field from every table
must have something entered in it. Does that happen?

It's likely that the query should not be using inner joins, even if the
tables have one-to-one relationships.
 
Back
Top