Data Bound Grid problem [RESOLVED]

[Talarin]

Hey all,

I'm using a data bound grid with an ado data connection. My db is Access '03 using MDAC 2.7. My problem is, after data is entered into the db, the dbg isn't refreshing properly, its always one record behind, i.e. after the first record is entered, the grid is blank, after the second record is entered, the first record displays in the grid. I never had this problem with SQL 2000, but Access is causing me no end of grief with this. Here's the code I'm using to display the grid after each insert:

strSQL = "Select * from MyTable"

AdoTrack.ConnectionString = cnnMydb
AdoTrack.RecordSource = strSQL
AdoTrack.CursorType = adOpenDynamic
AdoTrack.LockType = adLockPessimistic
AdoTrack.Refresh
dbgTrack.ReBind

Any ideas? Thanks in advance.