To record the filtered number of a record in a field on the form

[AllanW]

I open some forms from others and populate them with some of the "parent" data. A counter system is built into Access such that they apear (at the bottom) as "1, 2 etc of "x" filtered". I wish to record this number (not the expression) in a field on the form. In other words, product 1, 2, 3 etc of this particular set of circumstances.

[June7]

Could try VBA code:

Me!fieldname = Me.CurrentRecord

Saving calculated value is usually a bad idea. What do you want to do if one of the products is later deleted? Do you want to renumber the records? Talk about a can of worms!

This sequential number could be dynamically generated on a report. Textbox on report has RunningSum property to accomplish that.