Database doesnt see all records until Table is opened

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
DMax on existing record to increment serialized # fails 1
New records don't display on form with combo box 1
Record selector on a sub-form 3
New Record issue 3
Open record in form using table Record Selector 7
The newly created record is now shown in the form 3
Form records has only 1 but should have many 1

Back
Top