Record Count On Form in Access 2007

  • Thread starter Thread starter pcm1977
  • Start date Start date
P

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?
 
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?
 
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?
Click to expand...

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