How to Show What Record You're On and How Many Total Records There Are in Your Microsoft Access Form

In this Microsoft Access tutorial I will teach you how to show what record you’re currently on and how many total records there are in your Microsoft Access form using the RecordCount and AbsolutePosition properties of a form’s RecordSet.
LEARN MORE:
599cd.com/Reco...
PRE-REQUISITES:
Command Buttons: 599cd.com/Comm...
Intro to VBA: 599cd.com/Intr...
On Current Event: 599cd.com/OnCu...
RECOMMENDED COURSES:
Access Developer 1: 599cd.com/ACD1
LINKS:
Recordset Properties MS: tinyurl.com/29...
CONCEPTS:
Form_Current
Me.Recordset.AbsolutePosition
Me.Recordset.RecordCount
Form_ApplyFilter
Me.Recordset.MoveLast
NOTES:
And yes, I know there is a Count property, and a CurrentRecord property for a Form. Why do I use the Recordset properties then? Well, the Form.CurrentRecord property is fine, but the Form.Count property doesn't work right if you filter the form. Try it.
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, recordset, recordcount, movelast, applyfilter, absoluteposition, Get Record Count, Count the number of records, record count, current record
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@havaljamal9952]

Loved the Bounce !!! WoW.... thank you for the Record absoluteposition !!!!

[@jamescox9205]

Rick, I would enjoy seeing the developer tips as well and I think others would appreciate it if your busy schedule would permit it. Enjoy the videos as always!

[@599CD]

Will do!

[@user-wt1lz4vt1b]

Thanks for the great effort. I need to paste a value into a set of specified rows in the table through VBA Code

[@599CD]

599cd.com/Ask

[@colinhursell9176]

Yes please, more developer tips!

[@599CD]

More to come!

[@ryeaton]

Love this stuff! Thanks, Richard.

[@599CD]

My pleasure!

[@Initial_Gain]

Wow, exactly what I was looking for: how to create a box that shows the current record in a group or set. I need it for my sampler keyboard database as it would show the file number of a sound in a directory in the drive. Thank you very much it was very tricky to guess. I didn't even know it's name, that is, the current record number. 🇲🇹

[@599CD]

Glad I could help!

[@jarvbox]

Great video and exactly what I was looking for. I stumble however as my form is a subform and doesn't seem to work unless you cycle through the records. Is there a workaround to trigger the VB code whenever the containing fom updates?

[@599CD]

599cd.com/Ask

[@PhilipMunkesø-d4q]

Did you find a solution @jarvbox?

[@jakeekaj2386]

This doesn't (display current record number in form) work in Access 365. Error message doesn't recognize ".absoluteposition" . The video was followed exactly.

[@599CD]

Well since I'm using Access 365 myself then you're probably doing something wrong - try again from the beginning

[@seanmahoney1077]

The absolute position is only valid within a sort order. If you change the sort order, the absolute position changes accordingly. I want my form to change sort order but remain on the current record. Changing sort order at runtime causes the recordset to go to absolute position 'first' ( 0 or 1 as you like)

[@599CD]

Thanks for sharing

[@jtflypegasus]

Thank you

[@Bruce-fp4nm]

This was very useful. I have a question on how to keep a subform updated if I add a record in the subform. Example. I open original form and subform shows "1 of 14" then I add a new record to the subform and it does not update until I close the form.

[@599CD]

I've never seen Access behave that way.

[@markies_gaming]

How about if you want to display the record on MAIN MENU FORM.. Is Possible?

[@599CD]

Sure

[@markies_gaming]

​​@@599CDsir how about By YEAR to display record.. example i want to display all record of 2022.. can you make a tutorial sir..

[@MousaAlKalbani]

Please do more and more developer s videos.

[@599CD]

Roger that

[@jerrydfowler3480]

Rick another great video thanks. Question at about 10:32 the RecCountBox goes from X of 29 to 1 of 1 after you took out the navigation menu. why was that? OH I see after the Bonus you show why, Duh I should just watch it all the way then ask questions. Thanks again.

[@599CD]

Great idea. :)

[@moustafaali6628]

Thank you for this information, but if the records are in a subform and the condition is applied from the main form, the counter does not change

[@599CD]

This video does not address subforms

[@Tefhnia]

I have a database with many participants, which all have an ID stored in a number field named “PartID” in my table named “1 - Participant Information”. Example: Sarah is set as number “88”. I use a combo box, with a drop-down arrow list to choose which participant’s information will appear on my form, using the “PartID” number that I selected - (this combo box is set to fetch values from another table). As an example, If I want to bring up Sarah’s data on the forefront of my form, I simply select “88” from the drop-down menu combo box. Sarah’s info is thus loaded on screen. My question: A - How do I create an event procedure (Using VBA - on a button) which will tell this combo box to change number and load a different number on screen. As an example - number “88” is loaded, but I want to press a button which will tell the combobox on the form to move from number “88” to number “89” - OR from number “88” to the previous number “87”. Please note that the GoToRecord function does not work, because I am using a record source from another table and that the record selector does not display my 122 participant records on that specific form. I want to know a way to do this using VBA to change the value selected on my “Part ID” combo box. Any help would be appreciated! 😊

[@599CD]

Post this in my Forum: 599cd.com/AF

[@moustafaali6628]

think you

[@599CD]

Wilcome

[@lyroxc]

i just wanna ask, what to do if i have 24 total records and if i go to new record, the number is still stuck with 24 rather than 25 :)

[@599CD]

You'll be on record 25 as soon as you type the first piece of data into it.

[@michaelkrailo5725]

Hint: test for me.newrecord

[@manjunath2483]

Text box specific characters count

[@599CD]

Eh?

[@manjunath2483]

Memo box words count

[@599CD]

Huh?

[@user-uu6mx1ko9s]

I reviewed more than 10 times. My box is blank

[@mr.faiqueshaikh5991]

Hi Uncle, I'm Faique Shaikh . I'm 11 Years. I Wanted To Make A Revenue App . In Which Can Enter The Revenue Every Month By Checking The Dash board.

[@599CD]

599cd.com/Ask

[@rabidfollower]

I also don't like the built-in navigation buttons because the user can't directly navigate to the desired record(s). So I often create navigation links like the ones you see on websites: < 1 2 3 4 5 | 6-10 | 11-20 | 21-30 | ... >

[@599CD]

It's funny you mention that... one of my members just asked if that was possible. Might do a video on it soon.