Form recordset not adjusting correctly

[CraigWarmy]

I have some code for moving the form from one room to another. It is a proposal form with 4 subforms on it. On the main form I have the 2 buttons. Next Room and Previous Room.

Previous Code:
If Me.Recordset.BOF = True Then
Me.Recordset.MoveFirst
Me.Caption = Me.RoomName & " Bidding"
Else
Me.Recordset.MovePrevious
Me.Caption = Me.RoomName & " Bidding"
End If
Me.Requery
'That's it..
Any other way to code this besides using SQL???

 

[RuralGuy]

Look at the code in Stephan Lebans Navigation buttons and see how he did it.