Cycle back to first record

  • Thread starter Me!Frustrated = True
  • Start date
M

Me!Frustrated = True

Is there a way to set a forms Cycle or other property (Single form,) so that
if a user is at the last record then navigating to the next record will take
them back to the first record?

Or perhaps there is another way to improve on what I'm trying to do. I have
a form for Equipment Maintenance that shows both current issues and those
that have been resolved. I put a very basic "Find" button on the form, so
that if multiple problems exist for the same Unit, the button will navigate
through each record for that Unit as follows:
Private Sub cmdProblems_Click()
Dim myAsset As Long
myAsset = Me.AssetID
Me.AssetID.SetFocus
DoCmd.FindRecord myAsset, , , , , , False

Problem is, FindRecord only gives me the option of starting at the first
record, or starting at the record following the current one. If the user is
looking at the most recent record, FindRecord will not go back to the start
and cycle through them again. Do I have another option?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top