How can I save the current record before a requery

[red22j]

What I want to do is simple:

basically i want to run the requery command on a subform, but save the current record. When I run requery currently, it goes to the first record. I can't rely on the currentrecord property, because records may have been added or deleted since the last requery.

Any help would be appreciated,
Jon

 

[SgtJarrow]

Don't rmember the exact syntax at this time (not at a box where I an figure it out), you will need to create a recordset clone of your subform, set the bookmark of the clone to the bookmark of the subform, run your requery, then reset you bookmark for the form back to the bookmark for the recordset clone.

I have used it before and it works....just can't gte to my code right now.... The secret to creativity is knowing how to hide your sources. - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com