Indication for existence of records in hidden tab

  • Thread starter Thread starter John J.
  • Start date Start date
J

John J.

I have a form with 2 tabs. When tab1 is in front I somehow would like to
show the user that there are records (or not) in the subform in tab2. What
is the best way to achieve this? Is there some common method to do this?

Thank you.
John
 
Add a textbox (txtCount) somewhere on the main form or first tab and use the
form's Current event to check and display the record count of the subform:

Me.txtCount = Me.SubformName.Form.RecordsetClone.RecordCount
 
This is excellent and I think more efficient as Dcount, the approach I was
heading!
I now managed to update the tab2's caption on the current event of the main
form. I will also fiddle around to update this caption when a subform record
is added or deleted.
Thank you.
John
 
Back
Top