Record Number

[GaryInMilwaukee]

What is the function(?) for A row number. By this I mean you can do DCount("*", "Owner") to get the number of records for a table, but I need to find out what number row I am at in a table. The table has 25k records and I do a find and am now in the 3300 row. In my private sub how do I find out the row number (in old paradox pal it was NRecord()=recnumber with recnumber becoming the 3300 as a variable.).

 

[vbaInet]

In code it's Me.CurrentRecord. If it were a report then you can do a Running Count with ease. Have a look at this:

http://www.access-programmers.co.uk/forums/showthread.php?t=189241&highlight=running+count