Count for each record

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All

Is it possible to have a textbox in the detail section of a continuous form
view that simply displays "1" for the first record, "2" for the second
record etc. I realise that "first record" "second record" etc is normally
not a valid concept in access, but for my purpose any order will do. I could
get what I want with a report by using the running sum property, but
unfortunately there seems to be no such property for forms.

Hope someone can help

Thanks
Leslie Isaacs
 
Leslie

Using the Form properties, in the format tab set Navigation Button to Yes.
This will display Record Navigation Buttons at the bottom of the form. As
you step through your records the number in the Navigation changes to show
the record number.

Allan Murphy
Email: (e-mail address removed)
 
Leslie Isaacs said:
Hello All

Is it possible to have a textbox in the detail section of a continuous
form view that simply displays "1" for the first record, "2" for the
second record etc. I realise that "first record" "second record" etc is
normally not a valid concept in access, but for my purpose any order will
do. I could get what I want with a report by using the running sum
property, but unfortunately there seems to be no such property for forms.
Click to expand...

You could have a bound text box with a default value of its previous value
+1 :

=Nz(DMax("MyFieldName", "tblMyTableName")) + 1

HTH - Keith.
www.keithwilby.com
 
Back
Top