Access - How to "show all records" after importing from a .csv?
Posted on 2009-07-16
I've got a Form with a button that imports .csv files. The Import command button runs a macro, and it works fine. However, after it imports the file to the underlying table, the form does not refresh the record count. For example, if I have 20 records before the import, it says 1 of 20 at the bottom of the form.
After importing 65 records, it still shows 1 of 20. Also, even though a GoToControl action was executed, the cursor is nowhere on the form.
Then I click on the first field in the Detail section, and (either) press F5 (or click on Refresh All on the Ribbon), the record counter reads 1 0f 85.
Any ideas on:
1) getting the cursor back on a control
2) forcing a "refresh" of the record count
I've tried a few different things, but nothing seems to work.
I'm running Access 2007 on Windows XP, FWIW.
Thanks - ub