He does this in his Fitness Series - Fitness 35

Access doesn't know what is visible on the screen at any given time, so it cannot "position" the row for you that way.  But you can use a trick to solve this.  Use a bookmark (a recordset's property) to remember your row's location.  Move to the last row.  Then move back to your bookmarked row.  Your row should now be shown as the top row on the screen.  Move up 4 rows.  Then move back to your bookmarked row.  Your row should now have 4 rows above it.  If there are fewer than 4 rows above it, this method will show whatever that is available to show without any error.  If you haven't already, take Richard's lessons on bookmarks.  The other posters will guide you to which videos to watch, since I'm unfamiliar with his courses.  If Richard hasn't done a video on "positioning" a row on the screen in this manner, I would suggest he do a Tech Help video on this.

Here is the VBA code to do the above:

Dim frm As Form, bm As Variant

' Store your subform in variable frm
Set frm = Forms![Your Main Form Name]![Your Subform Name].Form

' Go to your desired row on subform however you prefer, such as with FindFirst
frm.Recordset.FindFirst "[customerID] = 100"  ' Criteria for your row

' Store your row in a bookmark
bm = frm.Bookmark

' Move to last row
frm.Recordset.MoveLast

' Move back to your row using bookmark
frm.Bookmark = bm    

' Move up 4 rows
frm.Recordset.Move -4

' Move back to your row using bookmark
frm.Bookmark = bm  


This way, there will always be up to 4 rows above your selected record UNLESS your selected record is near the bottom of a long list, in which case Access cannot scroll down far enough to show only 4 records above yours.

Thanks Kevin and Donald, I'll check out Fitness 35 and this vba code tommorow.  Thank you for getting back to me so quickly.