Navigation Buttons

[rby3iii]

First time user - so please forgive if this is already out there.

I want to hide the navigation buttons on a form and create a custom set of controls. I can create the buttons themselves but am having trouble with the "N of X", where:

X is the total number of records in the query, and
N is the current record showing in the form.

I can get X but how would I capture and display "N".

Any help would be appreciated.

 

[trucktime]

X of Y

Check this link:

http://www.access-programmers.co.uk/forums/showthread.php?t=85863

 

[accessman2]

Hi,

I want to create custom button, too.

The above link does NOT work.
How can I show N of X?

Please let me know, thanks.
When calculating the X and N, do I need to set up DAO.Recordset, CurrentDB, something like, if use them, will it run so slowly?

Please let me know, thanks.

 

[Rich]

Me.txtCurrRec = Form.CurrentRecord
Me.txtTotalRecs = Form.RecordsetClone.RecordCount + IIf(Form.NewRecord, 1, 0) & " " & "(filtered)"

 

[ghudson]

Record X of Y

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

Record X of Y