Stuart McLachlan
stuart at lexacorp.com.pg
Thu Sep 4 01:32:59 CDT 2008
One way:- Two text boxes in the form's Footer: txtCurrent and txtCount Set txtCount's control source to "=Count([ID])" where [ID] is a field in the forms recordset txtCurrent is unbound. Insert the following in the form's On_Current event: Private Sub Form_Current() txtCurrent = Me.CurrentRecord End Sub On 4 Sep 2008 at 15:27, Darryl Collins wrote: > Hi All, > > Am sure this is easy (which usually means it turns out to be absurdly complicated!!). I have my own custom Nav button on the bottom of a form, but it would be nice to have: "Record x of y" showing somewhere down the bottom like it does when you have the built in Nav buttons visible. > > I tried to search for this, but I must be getting the syntax wrong (or the words are too common - not really getting the results I need). > > Any pointers? > > Cheers > Darryl > > This email and any attachments may contain privileged and confidential information > and are intended for the named addressee only. If you have received this e-mail in > error, please notify the sender and delete this e-mail immediately. Any > confidentiality, privilege or copyright is not waived or lost because this e-mail > has been sent to you in error. It is your responsibility to check this e-mail and > any attachments for viruses. No warranty is made that this material is free from > computer virus or any other defect or error. Any loss/damage incurred by using this > material is not the sender's responsibility. The sender's entire liability will be > limited to resupplying the material. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Stuart Mclachlan