Record Count On Form in Access 2007

[pcm1977]

I have recently updated from 2003 to 2007 (I know a bit behind still)
and i had this database that i am running in compatibility mode,
because there are still people who use this database in 2003.

The issue i am having is that the top of the screen had some custom
navigation buttons and an unbound text box with the following code:

=[CurrentRecord] & " of " & [Recordset].[RecordCount]

This code worked fine in 2003, but now in 2007 it does not work at
all, just displays #Name? Am i missing something?

 

[Douglas J Steele]

See whether using the Me keyword makes a difference:

=[CurrentRecord] & " of " & Me.Recordset.RecordCount


"pcm1977" wrote in message

I have recently updated from 2003 to 2007 (I know a bit behind still)
and i had this database that i am running in compatibility mode,
because there are still people who use this database in 2003.

The issue i am having is that the top of the screen had some custom
navigation buttons and an unbound text box with the following code:

=[CurrentRecord] & " of " & [Recordset].[RecordCount]

This code worked fine in 2003, but now in 2007 it does not work at
all, just displays #Name? Am i missing something?

 

[pcm1977]

See whether using the Me keyword makes a difference:

=[CurrentRecord] & " of " & Me.Recordset.RecordCount

"pcm1977"  wrote in message


I have recently updated from 2003 to  2007 (I know a bit behind still)
and i had this database that i am running in compatibility mode,
because there are still people who use this database in 2003.

The issue i am having is that the top of the screen had some custom
navigation buttons and an unbound text box with the following code:

      =[CurrentRecord] & " of " & [Recordset].[RecordCount]

This code worked fine in 2003, but now in 2007 it does not work at
all, just displays #Name?  Am i missing something?

Sorry that did not work. Still the same error #Name?