add own text box to display number of records

[tizwaz]

I just want to add to a form a box which says 1 of 50 or 3 of 50 like the record selector box at the bottom of the forms. I can manage 1 of 50 by just typing = 1 of and then count the id. How can I get it to change to 2 of when I move to the 2nd record?

 

[VRoscioli]

In the form's On_Current event, you need to add the code to update the text box.


-V

 

[PHV]

A starting point:
Me.Recordset.AbsolutePosition + 1 & " of " & Me.Recordset.RecordCount

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tizwaz]

Thanks I've put that in the on Current event - how do I get it to update my text box

 

[PHV]

Me![textbox name] = (Me.Recordset.AbsolutePosition + 1) & " of " & Me.Recordset.RecordCount

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tizwaz]

Thanks that is working great thanks