Records in table not showing on form Access 2007
If you import data and it seemingly disappears, you need to check the indexes on that table. You should do the following:


Switch the table into Design View
In the Table Tools Section, under the Design Tab, click on Indexes
You will see a list of Indexes pop up


If any of the Indexes have one or more columns that are unique, those rows may have vanished upon import. You may need to either remove all indexes (do not touch the PrimaryKey) or Change the Unique Property on all Indexes from Yes to No.

Then, just reimport the data.

If all 235 rows are in the table already, go to your form's Property sheet. Click the Data Tab. Look at the Record Source and see if it is a table name or query.

You need to also go back to the Property Sheet, Click the Format Tab. Look over the Default View and set it to Single Form. This will view the table rows one row at a time. Click the Last Record Navigation Button. It had better say 235 of 235.