If I have a DBList with a list of book titles and once you click on a title all info related to that title is displayed. How can I get a label showing "Record x of so many records" once I have clicked on a title.
I am using a data control and I have already tried this command:
label.caption = "Record " & CStr(datDisplay.Recordset.AbsolutePosition) _
& " of " & CStr(datDisplay.Recordset.RecordCount) & " Filtered")
The problem is that because AbsolutePosition is set at 0 every time I click a label it comes up as "record 0 of 5 filtered"
