Cancel closing of a subform at mainform unload

[JennieL]

Hi:

I have a main form with a subform. I am trying to cancel closing where user left a null value on subform.

Works fine if I test with main form only, but when I try cancel = true at onunload on main form with subform, I can't get closing to stop.

It seems as though subform is closing before event can view for nulls.

Does anyone know of a way to cancel closing of subform from main form?

Thank you.

 

[TheAceMan1]

How are ya JennieL . . .

Forms open the inner most subform out to the parent. [blue]The order is reversed when closing.[/blue] So using the mainform [blue]Unload[/blue] event is correct.

Are you sure your referencing the subform control correctly?

[blue] If Trim([purple][subFormName].Form!ControlName[/purple] & "") = "" Then Cancel = True[/blue]

See Ya! . . . . . .

 

[JennieL]

Hey AceMan:

I will give that a try. Thanks for your help.

JennieL