Question on AbsolutePosition

[Mala R.]

I have a form with a filter On. After I click the new record button I want
to get back to the previously viewed record. I tried using
Recordset.AbsolutePosition. But with the filteron it doesn't access the
correct record. Is there an easy way to get the record

 

[Graham R Seach]

Mala,

You can store the Bookmark of the record you want to remember, and then use
that Bookmark to return to the previous record. But in any case, you'll need
to remove the filter.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html