calculated caption on tab control

[RichardP via AccessMonster.com]

Re: calculated caption on tab control

Thanks for that Wayne, yes apologies for leading you astray there - I was
typing untested code directly into this message and neglected to include the
".Form" property - will try to re-read before posting in future!

Wayne Gillespie wrote:

>>However, this is making an assumption that the recordcount you wish to
>>display is the one of your main form. If the recordcount required is the

>[quoted text clipped - 17 lines]

>>
>>but no can do, Access doesn't like that...

>
>You are not referencing the subform correctly, you are referencing the subform
>control, NOT the subform contained within the control. You need to add .Form.
>before the RecordsetClone -
>
>With Me.frmPWExpense sSubform.Form.R ecordsetClone
If Not .EOF Then
.MoveLast
End If
Me.Page28.Capti on = "Expenses [" & CStr(.RecordCou nt) & "]"
>End With
>
>I would try this code on the Form_Load event as the subform data may not have
>been loaded fully when the Form_Open event fires.
>
>Wayne Gillespie
>Gosford NSW Australia

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200609/1