I have a stupid question (so finish swallowing now... I don't want to
be accused of any beverage-related mishaps).
I have a form with several subforms, with each subform on a separate
tab. I'm trying to loop through the subforms so that I can set the
caption of the tabcontrol page to something like <SubName>
(recordcount)
Okay, now the two dumb questions...
1. why do these subforms think they're called "tbl..." when I saved the
subforms with a "sfrm" prefix?
for a sanity check, I looped through the form's controls and got some
weird results - the forms were'nt always named "sfrm...", some were
"tbl..."
Dim ctl As Control
For Each ctl In Me.Controls
'If Left$(ctl.Name, 4) = "sfrm" Then
' Debug.Print ctl.Name
'End If
If TypeOf ctl Is SubForm Then
Debug.Print ctl.Name
End If
Next ctl
okay, second dumb question - to eliminate the mad blinking caused by
the OnCurrent event of the mainform requerying the subforms... should I
use just the subform's RecordCount property?
I have Keri's article from AccessWeb (examples of syntax for referring
to various objects) - I'm just trying (in vain) to figure out how to do
this right
Do you use .RecordsetClone.Recordcount in this instance?
Thanks!
Pieter