Select a Record to Get Focus in Detail Section of a Form

[EddieN1]

I have a simple form with a header, detail, and footer. The detail lists a bunch of records in sequence for the operator to select from. I would like to include all records in the table, but I would like to select the record to be at the top of the display for the operator to begin his search. Any ideas?

[June7]

You can go to a particular record otherwise need criteria to sort records into an order that will result in the desired record at top.

[EddieN1]

It turns out that if I put the following code in the Form's Load Event:

Me.RecordsetClone.FindFirst "JobNbr >= '" & pubJCMasterFiscalYear & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

the list of Jobs is the entire list, but the first job of the fiscal year is shown on the top row that is initially displayed. However, the user can still scroll to an earlier or later job number.

Thanks, Eddie

[June7]

Yes, one way to 'go to' a record. Very nice. Congratulations!