Display specified record in table

[roaftech]

I normally enter data using appropriate forms but from time to time I need to look at a particular record in the raw data (table). I use the following code behind a button in the calling form:

Private Sub OpenPersonsTable_Click()
' opens DataPersons table for general edit
    strTblName = "DataPersons"
    idFilter = Me.BID    'BID is a form control with the target identity, as used in the primary key of the table
    
    DoCmd.OpenTable strTblName, acViewNormal, acEdit
    DoCmd.FindRecord (idFilter)

End Sub

This is fine, except that the chosen record always shows up as the last record in the table window and I would prefer to be able to see the adjacent records as well. How can I use vba to scroll down and back up so that my chosen record is nearer to the vertical centre of the window?
Note - Access 2003!

TIA

[CJ_London]

having found the record, you then need to move back up 5 or 6 records - the number determined by the number of records in the table, the size of the window and the number of rows currently being displayed in the window.

You would normally do this in a form, I don't think you can do it in a table. The form could simply be a datasheet view of the table.

if you have a subform to display the information, you can simply set the controlsource to 'Table.myTablename'. Or if you want the table to be viewed as a popup, create a blank popup form with just a subform control sized to suit, pass the table name as an openarg and some code in the form open event - subformcontrolname.controlsource="Table." & openargs

[andy49]

could you create a query which "focusses" on the 10 values either side of your chosen ID?
Not sure it would work though

[roaftech]

Thanks for the prompt responses - will explore further.

[roaftech]

The forms approach would give more control but I found that adding these two lines of code to my original sub does what I want:

    DoCmd.GoToRecord , , acNext, 5
    DoCmd.GoToRecord , , acPrevious, 5

Now I might explore how to control the window size, but that is not a priority.

Thanks for the ideas.

[CJ_London]

glad you found a solution