Display currentrecord on form that has subforms

  • Thread starter Thread starter wazza_c12
  • Start date Start date
W

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
 
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
 
Back
Top