control main form navigation when sub form total does not balance

[maxscott]

I have a main form with a field xvalue.

I then have a subform - each record has a field iamt. I can sum iamt for related records and this goes into txtSumAmt in main form.

I want to prevent updates of the main tables if xvalue <> txtsumamt.

I can stop the update on the main form using a Before Update Event with

if me.xvalue.value<>me.txtsumamt then
cancel=true
exit sub
endif


But this won't let me go back onto the subform to edit the values of iamt.

How can i get round this?

Thanks

Max

[Micron]

You might want to put the BeforeUpdate event on the subform instead. I think either way, you'll need to invoke Me.Undo, which would roll back the changes. I presume it would be better to roll back a subform change as it's likely one control that's causing the discrepancy. Note that if you undo the main form, every change will be rolled back. If that means 10 controls, then ten it is. That's the only way I know of escaping a record change that was cancelled by the BeforeUpdate event.