I had the same problem once and I found that the error for "Record out of range" was using my form's table for e.g. : myform.scx

you can check it by using

use myform.scx
brow

check it!!

Rajesh