Goto specific record in recordset

[TJBernard]

I am trying to go to a specific record in a recordset (on a form).

In the past I as using the typical open the form and use the filter to go to the specific record:

strLinkCriteria = "Where ID = 5"

Docmd.openform "frmName", , strLinkCriteria

This takes me to the correct record, but filters the form down to that one specific record. The users instead would like to go to the specific record, but be able to see all the other records for the form correctly.

Is there anyway to do this?

Thank you,

T.J.

 

[TJBernard]

Never mind, I found the code in another database, I asked prematurely.

Sorry for the post, feel free to delete if you want.

If you would prefer I post the code instead, let me know.

Thank you,

T.J.

 

[wazz]

sure, post the code.