Results 1 to 3 of 3
  1. #1
    Needlejockey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2012
    Location
    Netherlands
    Posts
    9

    Record number in Form


    Good morning everyone. I am trying to add the record number to my main Form. I have managed to create a text box with ' "of" & Count(*)' which nicely shows the total number of records, but I have been unable to find a way to get the current record number into the text box to show (for example) '4611 of 6000'. I have checked several books (Prague & Irwin, Viescas) but so far I'm none the wiser. Is it possible? If so, how do I do it?

  2. #2
    Join Date
    Dec 2009
    Posts
    7
    Hi

    =[CurrentRecord] & " of " & Count(*)

    Sucess!

  3. #3
    Needlejockey is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2012
    Location
    Netherlands
    Posts
    9
    Thanks very much for helping me out. It worked like a charm!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 07-06-2013, 05:13 PM
  2. Replies: 6
    Last Post: 07-25-2011, 01:54 PM
  3. Current record number
    By turvoll in forum Programming
    Replies: 1
    Last Post: 11-04-2010, 10:09 AM
  4. Making New Record Number Next Numerical Number
    By jhillbrown in forum Access
    Replies: 1
    Last Post: 03-10-2010, 11:06 AM
  5. Replies: 1
    Last Post: 04-25-2009, 01:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums