no current record 1

[matrixindicator]

Set rst = dbs.OpenRecordset("TblFileRecordCount", dbOpenDynaset)
    rst.MoveFirst
    rst.MoveLast
    rst.Edit
    rst!fileName = strFileName
    rst.Update
rst.Close

Hey,

If you like to fill up data in a table with a recordset and the table is empty you get the error "no current record".

Is a basic question, I can't remember how to fix it easily.

 

[Remou]

Set rst = dbs.OpenRecordset("TblFileRecordCount", dbOpenDynaset)
If Not rst.EOF And Not rst.BOF Then
    rst.MoveFirst
    rst.MoveLast
    rst.Edit
    rst!fileName = strFileName
    rst.Update
End If
rst.Close

 

[matrixindicator]

thx for this quick response