Inserting A Number In A Field Based On Navigation Buttons...

  • Thread starter Thread starter zrag via AccessMonster.com
  • Start date Start date
Z

zrag via AccessMonster.com

Hi all,

I have a form, with a subform. I have a field that I am trying to have
self populate, based on the corresponding number that is located in the
navigation buttons section. For example, if in the navigation piece it
says I'm on record 31 of 72, then I want this field to have the number 31.
Make sense?

Is this possible?

Thadks in advance!
 
You didn't say where the field is located... on the Main form or the
Subform.

Set the ControlSource to:
(if on Main) = frmYourSubformName.Form.CurrentRecord
or...
(if on Sub) = CurrentRecord

The Sub field will require a Refresh when OnCurrent for each subform record.
hth
Al Camp
 
zrag,

This is not a good idea. The number shown on your form will not always be
tied to the same record. Insertions, deletions, filtering, or changing sort
order will cause different numbers to show for the same record. What you see
as a record number on the form is only relavent to your current session. If
you need to number records, then you should think about using an autonumber
field, or using some other way to assign incremental numbers to records.

In reality, there is seldom a need to use a record numbering approach these
days.
 
Back
Top