Can't view table records in datasheet view

K

Ken Warthen

I have a form that I use to add contact and event particpation records to
their respective tables in an Access 2007 database. If I open the tables in
datasheet view Access does not display all of the records. I have a function
in a module that I use to return a record count for a given table. In the
case of tblContacts where 17 records are displayed, there are actually 377
records. In the case of tblEventParticipants where 27 records are displayed,
there are actually 30 records.

This is pretty baffling. Anybody have any idea on what might be going on
here?

Ken
 
R

ruralguy via AccessMonster.com

Does "Filtered" show up on the status bar for the table? If so, can you click
it and get it to toggle?

Ken said:
Directly
Are you opening the tables directly or through queries?
Click to expand...
[quoted text clipped - 10 lines]
Click to expand...
 

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

Help calculating totals from linked table in datasheet view 2
Lookup current record with ComboBox, any changes create new record 3
Datasheet in split form is empty (running using Access 2007 Runtim 1
delete records in one table that occur in another table 0
How to refresh a single record in a datasheet subform? 1
Bound checkbox in datasheet subform 2
display join-table records in multi-select list box 2
Form view Datasheet 1

Top