Access form record count

[WorkHorse]

How do I get the query count to display on an Access form?

I have a form in MS Access and want to simulate the navigation controls. So it says "This is record X of Y". X = Me.CurrentRecord. But what is Y? I tried Me.Count but it doesnt give the right number. The form sources a query, and I want to display the number of records in the query. Sorry, not real handy at Access forms. Any help would be appreciated. Thanks.

[SergioV]

Hi !

Testing I found that TextBoxes in a Form with the values :

1.- "=CurrentRecord" gives me the same that you say AND

2.- "=Count(*)" gives me the total number of records in the source Query.

Hope it works for you.

[mendhak]

Me.Recordcount

[jbrumbau]

This was really annoying or me to figure out from a subform (it doesn't work if your main form has more than one subform). The workaround for a subform referencing a parent's recordcount is the following line of code:

Set sqlrs = CurrentDb.OpenRecordset("Select Count(*) AS My_Count FROM [" & frm.Parent.RecordSource & "]", dbOpenSnapshot, dbReadOnly)  
varRecordCount = Nz(sqlrs![My_Count], 0)