Record number x of y 1

[yoshi88]

I dont want to use the navigation bar in a form, but I want the user to know how many record there is and on wich he is working on. I create an unbound text box with this code in the control source.

=[CurrentRecord] & " of " & Count(*)

Its working well, but if I add a new record the "of y" section doesn't uptdate. I tried many thing like after update, a requery, ... but it never work. The only way to refresh it is to close the form and to open it again. Does anyone has any idea.

François

 

[gusbrunston]

I tried to solve this, and like you, I could not. However, in the property sheet for your form, select the "Format" tab, and then select "Yes" for "Navigation Buttons": then the built-in buttons will show at the bottom of your form, and accomplish what you are trying to do. Good luck!
Gus Brunston
An old PICKer
padregus@home.com

 

[gusbrunston]

Oops! I re-read your posting just now and understand that you did not want to use the navigation bar. Sorry, I'm not any help at all.
:-I Gus Brunston
An old PICKer
padregus@home.com

 

[jurgen]

sub AkarMi()
Dim dk As Recordset
Set dk = Me.RecordsetClone
dk.Bookmark = Me.Bookmark
MsgBox "Total records: " & dk.RecordCount
MsgBox "Current record: " & dk.AbsolutePosition + 1
End Sub

Here it's a had the same problem

 

[jurgen]

oh forgotten

put it on current record section of the form


JJ