Move next unless record is matching then skip

[Ruegen]

I want users to skip a record if it is open using another form

so far I have it that if it matches the id of the other form I get a true result in which case I want it to skip the current record by moving to the next or previous or close if there is only one record shown on the form

I'm not sure how to do this



can I use Me.Recordset.MoveNext but have it do the tasks described if it has reached the final record ?

[Ruegen]

I am using...

'checkto see if school is already open on another form
If cycleFoundSchools(Me.NewSchoolsID, Me.Form.Name) Then
    If Me.Recordset.EOF Then
        If Me.Recordset.BOF Then
        MsgBox "You have this record open and you only have a recordset of 1 so the form will now close"
        DoCmd.Close
        Else
        MsgBox "You have this record open already in another record, moving to the previous record"
        Me.Recordset.MovePrevious
        End If
    Else
    MsgBox "You have this record open already in another record, moving next record"
    Me.Recordset.MoveNext
    End If
End If

but I could be wrong, it seems to be working fine.

Actually the problem now with the above code that if there is more than one record in a set, it moves forward skipping it but if I move backwards it moves forward so not sure how to get around.

Basically if I move forward or backwards I want to "skip" the record - not sure how.

[Ruegen]

Derp... Anyone?