Cycle back to first record?

[Me!Frustrated = True]

I use a form (single form) for Equipment Maintenance that shows both existing
issues and those that have been resolved. I added a simple "Find" button
that should navigate to any records that exist for any recurring problems
with a particular unit. Here is the button code:

Private Sub cmdProblems_Click()
Dim myAsset As Long
myAsset = Me.AssetID

Me.AssetID.SetFocus
DoCmd.FindRecord myAsset, , , , , , False

End Sub

My problem is, I can only set the options for FindRecord to either start
searching at the first record, or at the one right after the current record.
If a user is looking at the most recent record, I would like the search to
start again at the beginning of the recordset. Is there a way to do what I
want using this method, or do I have to use another method? Or, can a form's
properties be set so that navigating to the "next" record will return to the
first record in the set?

TIA

 

[Allen Browne]

message

I use a form (single form) for Equipment Maintenance ...

Even if you are frustrated, please do not post the same question, multiple
times and in multiple groups.