Navigation Buttons option set to "No"

[frankbutcher]

Hi All.
I have a form with the "navigation buttons" option in format set to No.

However, I would like to put e.g "Record 1 of 5" etc on the for, and it obviously to change when a new record is added.

Can this be done?

Thanks.

Frank.

 

[indesisiv]

Yes,
Create an ubound text box on a form and put the code under this 'current' event of my form:

Me!TextBoxName = "Record " & CurrentRecord & " of " & Me.RecordsetClone.RecordCount

That should do it.

Steve

 

[frankbutcher]

Thanks!

That works a treat

Thank you very much Steve.

Frank.