See 1 of 6 with RecordCount & AbsolutePosition

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.

Pre-Requisites

• Command Buttons: https://599cd.com/CommandButtons
• Intro to VBA: https://599cd.com/IntroVBA
• On Current Event: https://599cd.com/OnCurrent

Recommended Courses

• Access Developer 1: https://599cd.com/ACD1

Links

• Recordset Properties MS: https://tinyurl.com/29t258tk

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.

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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