Repainting a Form

[Mike Henry]

I have created a form that asks the user for the location
of a xls file. It loads the data from the xls
spreadsheet to a recordset in Access. I have to look at
each individual record to determine what table they go
into. What I'm trying to do is inform the user on the
form of how many records are contained in the form and at
what position the current record is at. However when I
use the Me.Repaint method or the DoCmd.RepaintObject
method the current form is not being refreshed.

thanks in advance for all your help,
Mike