Code Modification

[dr223]

Hallo,

I a main form called StudentDetails1, and a subform called FeeDetails and a field within the subform called Session.

I have a button on the main form and a text box which displays the record stored in the field (Sesion) and you can go foward and backward by pressing the buttons on the main form.

The code is as follows:


On Error GoTo Err_Command89_Click
DoCmd.OpenForm "StudentDetails1"
DoCmd.GoToControl "FeeDetails"
DoCmd.GoToControl "Session"
DoCmd.GoToRecord , , acPrevious
Exit_Command89_Click:
Exit Sub

Err_Command89_Click:
MsgBox Err.Description
Resume Exit_Command89_Click

What I want to do is that if the data in the field (Session) is duplicate to jump and highlight the next field.

The Session are like 2005/06, 2006/07, 2007/08.

However, sometimes you might have 2005/06, 2005/06, 2005/06, then 2006/07. So when you press the forward and backward buttons I want it to hightlight 2005/06 then 2006/07. Rather then 2005/06, 2005/06, 2005/06 then 2006/07 or vice versa

Any help!!! Thanks

Thanks