Hi there
I am trying to display the current record number on my form (in a text box)
with the total records in my recordset in another text box (for example "Record 1 of 20").
I can get the total record count easy by building uisng the following code in the on_load event of the form. The code that I am using is:
=Count([tblCustomerQueryTracker]![CustomerQueryID])
however i'm having great difficulty (when using my next, previous buttons) to display the current record number. Please can anybody help me.
Thank you very much in advance
I am trying to display the current record number on my form (in a text box)
with the total records in my recordset in another text box (for example "Record 1 of 20").
I can get the total record count easy by building uisng the following code in the on_load event of the form. The code that I am using is:
=Count([tblCustomerQueryTracker]![CustomerQueryID])
however i'm having great difficulty (when using my next, previous buttons) to display the current record number. Please can anybody help me.
Thank you very much in advance