Bookmark

[Middlemarch]

Can't quite figure out the correct syntax... been trying various forms of

Dim b As DAO.Recordset
Set b = Forms.Form1.Datasheet.Form.RecordsetClone
Forms.Form1.Datasheet.Form.Bookmark = b.Bookmark
 Forms.Form1.Datasheet.Form.Requery
 Forms.Form1.Datasheet.Form.Bookmark = b

The aim is to requery the Form and return to the same record.

[Gicu]

Try to requery the form's recordset instead:

Forms!frmYourForm.Form.Recordset.Requery

Cheers,

[Middlemarch]

That gives me Object doesn't support this property or method
My forms name is Datasheet and it's a subform on Form1.
I tried "." and "!" but same error.
And should this work without Bookmark ?
Thanks

Later... I found Forms.Form1.Datasheet.Form.Recordset.Requery works, even though I thought I'd tried that first.
Can you say why the "." not "!" ?

[Minty]

Datasheet is a reserved word and I would therefore think a bad choice of name for a form.
Try enclosing it in square brackets? Or better still call it something else like frmDataSheet?

The Dot and the Bang - long discussions here:
https://www.access-programmers.co.uk....202806/page-2