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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter on Subform Not Displaying as Expected 1
First Subform record gets modified when closing form 3
Main Form and two Subforms 2
Trouble associating parent form record to subform's record 1
Main Form with Subforms 5
Problem: Display Record # of # on continuous subform? 2
filtering a form based on the values of a subform 0
Unremovable horizontal scroll bar on subform 1

Back
Top