Previous Records Lost?

D

danthonyjr

When I enter data into the form, it feeds into several tables. When I close
the database and reopen it, the data is saved in the tables, but previous
records do not appear on the form.

The data entry setting is "NO," so I don't understand what else could be the
problem. Could someone please help?

Thanks.
 
J

John W. Vinson

When I enter data into the form, it feeds into several tables. When I close
the database and reopen it, the data is saved in the tables, but previous
records do not appear on the form.

The data entry setting is "NO," so I don't understand what else could be the
problem. Could someone please help?

Thanks.
Click to expand...

It's quite likely that the form is based on a multitable query, and that not
all of the tables contain records. The default Inner Join will show data only
if every table has data related to the "main" table.

For this - and many other - reasons, it's usually best NOT to create one Great
Master Query and attempt to edit it. Instead, use a Form for the "one" side
table in the relationship, and Subforms for the "many".

Perhaps you could post the SQL view of the recordsource of your form, or
describe its structure in some more detail.

John W. Vinson [MVP]
 
C

Carl Rapson

danthonyjr said:
When I enter data into the form, it feeds into several tables. When I
close
the database and reopen it, the data is saved in the tables, but previous
records do not appear on the form.

The data entry setting is "NO," so I don't understand what else could be
the
problem. Could someone please help?

Thanks.
Click to expand...

Is the Allow Additions property set to True?

Carl Rapson
 
Top