Navigation Buttons not working

[handlebarry]

Hi - I have a problem with a subform used to view notes added by users. The subform is in continuous forms view. (There is also another subform on the same page used to add notes - both use the same table).

The notes added are often much longer than the text box can show, so I thought I would add a verticle scroll bar. The scroll bar only appears in the first record. Also users cannot click in the text box of the next record.

So I thought I show the record selctor, however this will not work. I have been adjusting the forms properties but nothing seems to allow the navigation buttons to work.

Can anyone point me in the right direction?

 

[handlebarry]

Hi removing the following allows the navigation buttons to work. But can anyone tell me why?

Private Sub Form_Current()

Me.OrderBy = "[Date] DESC"
Me.OrderByOn = True

End Sub

 

[handlebarry]

moved the OrderBy to On Open and it works fine