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
 
K

Ken Warthen

Directly

ruralguy via AccessMonster.com said:
Are you opening the tables directly or through queries?



--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
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
datasheet view 1
Controlling Columns in Datasheet View 7
form/subform-type functionality in datasheet view 8
DataSheet Defalt View 1
Switch from datasheet to form view - select first record 1
Hide + column in Datasheet 2
Datasheet View subForm and Form View subForm on same Master Form 5

Top