Toggle Allow Additions

[Pendragon]

Access03/WinXP

I have set a subform's Allow Additions property to False. When the user
clicks on a command button on the subform, after a set of conditions are met,
the Allow Additions property is set to true.

I would like the Allow Additions property to be reset to false once the user
clicks off of the subform to a different control in the current record, or
moves to another record (via Find Record combo box).

Where is the best place to reset the Allow Additions property back to false?
I have tried the subform's LostFocus and Deactivate property, but this has
not worked.

Suggestions greatly appreciated!!

Thanks.

 

[theDBguy]

Hi,

Depending on your conditions, I would probably try using the Current event
and check for the NewRecord property.

Hope that helps...

 

[Allen Browne]

If you want to set AllowAdditions back to No at the point when a new record
has been added, you could try the AfterInsert event.