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_BeforeUpda te() 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.