Hello,
I have custom navigation buttons on my form. I use the OnCurrent event of the form to enable or disable the next and previous buttons when the form is on the first or last record. I use the (me.currentreocrd=1) and (me.currentrecord=recordset.recordcount) to mark the beginning and end of the records.
The problem is that when the filter is on, this doesn't behave as I intend it to do, and I understand why it shouldn't. What I am thinking is to add an If statement for Me.FilterOn=True, and then mark the beginning and end of the filter. Is this possible? Please help. Thanks in advance.