Database doesnt see all records until Table is opened

[Guest]

When I open the database, which opens directly to a form. Previously entered
records do not appear and the record selector shows only the current record.
If I close the form, open the table, close the table and reopen the form,
then the record selector sees all the records. FYI, the form is based on a
query not direct to the table?

 

[Rick B]

Sounds like your form has the "data entry" property set to true. If so,
that will not allow you to see previous entries, only add new ones or see
entries made by you since you opened the form this session.

Turn off that property and you should see all the records (assuming your
record source does not limit the records in some way.

If turning that off does not get you the desired results, post back.

 

[Guest]

Rick,
Sorry it is already set to NO. Any other suggestions?

Mark

 

[Rick B]

What is the data source for your form?

If it is a query, please paste the SQL of the query here so we can see it.
Does the query include any criteria that would limit the records displayed?

Are there any filters applied to your form?

 

[Guest]

Can't explain it, but we found the Splash Screen was the culprit.
Thanks for the help