The error 2046: GoToRecord' isn't available now

[arnelgp]

on bound forms, Recordset property is the recordset from the bound table or query of that form.

using:

set db=currentdb
set rs = db.openrecordset("select …")

if you are "selecting" from same Recordsource(table or query) of your form, you are actually fetching fresh records (new, updated) from that table/query. therefore this recordset might not be of same record count as what you have.

while using:

set rs = me.recordset

is a safe method, because you are using the current record that you have in your Form.
there is also a RecordsetClone property which is same copy of Recordset.
moving through the clone recordset (.movenext, .moveprevious) will not move the record pointer
in your form. on the contrary, moving through records in Recordset will move also the cursor/record pointer
of your form.

you can google "ms access recordset recordsetclone" further.

 

[Babycat]

Thank Arnelgp.

This is useful to me to learn.
I have read anout recordsetclone, will play with it

Thanks, Xuan