Process form after subform is filled

[acauchi]

I have a form with a subform with it. Each time I update a record in the form i note changes in the subform.How can I prohibit user from submitting changes to form if subform is not filled in. Want to make sure that user does not forget to make annotation in the subform.

thanks

[MMcCarthy]

You need a validation routine on the save button that will also have to be triggered on form close (auto save).

I would suggest using the "On Dirty" event on the main form. This will trigger if any changes have been made to the main forms record since the last save. Add a checking routine to see if certain fields on the subform have been changed and if not you can cancel the save and close events and send a message to the user.

Mary

[NeoPa]

I would have thought the Form_BeforeUpdate() event procedure would be the best place to put this. It's quite conceivable that the form will get updated before all required changes have been made. It is only a problem if this state persists at time of attempting to save away the record.