Previous Records Lost?

[Guest]

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.

 

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

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]

 

[Carl Rapson]

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.

Is the Allow Additions property set to True?

Carl Rapson