Form will not display records

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?
 
L

Linq Adams via AccessMonster.com

If the Data Entry Property of the form is set to Yes, this is the expected
behavior.This setting only allows new records to be entered,. It does not
allow existing records to be displayed.

Despite its name, Data Entry does not have to be set to Yes in order to enter
records. AllowAdditions and AllowEdits set to Yes will allow new records and
existing records to be seen, as well.
 
P

PA

Thanks for the reply - but Data Entry is set to No.
Any other thoughts will be greatly appreciated.
 
D

Dirk Goldgar

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.
 
Top