Can you post the rest of your code, specifically the line(s) that open the
recordset?

On Fri, 5 Nov 2004 13:41:14 -0600, silvest
wrote:


Hi, i'm not too familiar with VBA in Excel, but i'll try my best.

I'm trying to run a macro that'll generate numbers and fit it into
Access DB (which i've created using another macro)

the loop seems to be running fine, but an error occurs saying: "Either
BOF or EOF is TRUE, or the current record has been deleted. Requested
operation requires a current record."
and points towards this line: "

-- Recordset1.Update <--
Recordset1.Close
Set Recordset1 = Nothing