G
Guest
Hi Folks,
Using Access 2003 with XPSP2.
I have designed a form (frmMain) with an embedded sub-form (frmSub).
frmSub contains a number of records that are displayed in continuous form
mode.
frmSub also contains a field (tbxCount) in its form footer that counts up
the number of records displayed in the Detail section (and seems to work ok).
What I want is for the change of the Count field to trigger the Change Event
so that - when the count reaches a given number (say 10) I can change the
AllowAdditions control to stop any additional records being entered.
At the moment all i'm using is a Debug.Print statement in the change event
for the tbxCount field to try and work out how to get the change event to
trigger. (So, it's not a naff piece of VBA stopping this working!!).
I've tried similar Debug.Print "Hello World" in the BeforeUpdate and
AfterUpdate events for this same field.
How do I get this to work? Is there a smarter way of acheiving my result -
to limit the number of records entered in frmSub to a predetermined number?
Thanks for the help.
Using Access 2003 with XPSP2.
I have designed a form (frmMain) with an embedded sub-form (frmSub).
frmSub contains a number of records that are displayed in continuous form
mode.
frmSub also contains a field (tbxCount) in its form footer that counts up
the number of records displayed in the Detail section (and seems to work ok).
What I want is for the change of the Count field to trigger the Change Event
so that - when the count reaches a given number (say 10) I can change the
AllowAdditions control to stop any additional records being entered.
At the moment all i'm using is a Debug.Print statement in the change event
for the tbxCount field to try and work out how to get the change event to
trigger. (So, it's not a naff piece of VBA stopping this working!!).
I've tried similar Debug.Print "Hello World" in the BeforeUpdate and
AfterUpdate events for this same field.
How do I get this to work? Is there a smarter way of acheiving my result -
to limit the number of records entered in frmSub to a predetermined number?
Thanks for the help.