Access 2007: I have a database that has numerous subforms to enter information for the various steps needed to process a Corrective Action. My problem is, when I enter data in the initial subform screen I cannot view it (example: enter new record #1000 and when you hit the "last record" button it goes to 999, when at 999 if you hit the "next record" button it goes to "New" like 1000 does not exist). I have of course verified that the information is in the table - and it is - but to view it I have to exit Access and then get back in, and then the record can be viewed and is the last record when the last record button is pressed. I even made a data entry form and when I enter data via that route the results are the same. HELP!