Record Count

I have a microsoft Access table that Ive created a user interface in VB for, I have a horizontal scroll bar to click through the records individually but i cant figure out how to print out a record count similar to the one in Access where it will say 1 out of 30 for example, then 2 out of 30 etc. etc., can anyone help me figure out how to translate the record count from the access table to the VB interface or how to create code in VB to calculate the current record and total records then display that information on the form.

Try using a SQL select statement such as:

SELECT COUNT(COLUMN_NAME)
FROM TABLE_NAME;

using a column that is classified as NOT NULL (that is, requires an entry for each record) to get a true count of the total records in a table.