[AccessD] Counting Records on Form (when Nav buttons are turned off)

Steve,

Many thanks, that works great once I get the form to requery the text box upon "On Current".  Adds a bit of overhead, but seems to be acceptable.

cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve Schapel
Sent: Thursday, 4 September 2008 4:22 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Counting Records on Form (when Nav buttons are
turned off)


Hi Darryl,

In the Control Source of an unbound textbox:
=[CurrentRecord] & " of " & RecordsetClone.RecordCount

... or variations on the theme.

Regards
Steve


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).
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

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.