Can't view table records in datasheet view

  • Thread starter Thread starter Ken Warthen
  • Start date Start date
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
 
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...
 
Back
Top