Display currentrecord on form that has subforms

[wazza_c12]

Hopefully this is an easy one

On an old database I had a field with a control source set to

=form.CurrentRecord

And the field would happily display the record number in the particular
result set.

I want to do the same thing in a new database/form .... but it's not
working

The main form is called "fm09_Search_Results"
It's record source is "qry04_Submission_Search"

This main form has multiple subforms based on other queries

..... How do I set a field to display the current record of the main
forms resultset?

Cheers

Warwick

 

[Michel Walsh]

Hi,


The Recordset AbsolutePosition property return the record position. Push
that value in the appropriate control in the onCurrent event handler:


Me.ControlName = Me.Recordset.AbsolutePosition



Hoping it may help,
Vanderghast, Access MVP