Saving Form and Subform

[sboegeman via AccessMonster.com]

Hello -

I have a master form and 4 subforms. The subforms are presented in 4 tabs.
The controls in each subform are checkboxes. Referential integrity is
established between the master and child tables. When the master form is
saved I'd like some code to check each subform for null or unchecked
checkboxes and deny the save all subforms are null or unchecked. Can someone
please let me know on how to proceed?

Thanks!!

Stece

 

[Rick Brandt]

Hello -

I have a master form and 4 subforms. The subforms are presented in 4
tabs. The controls in each subform are checkboxes. Referential
integrity is established between the master and child tables. When
the master form is saved I'd like some code to check each subform for
null or unchecked checkboxes and deny the save all subforms are null
or unchecked. Can someone please let me know on how to proceed?

Can't be done. Whenever you move focus from subform to main form, subform to
subform, or main form to subform, the form losing focus is saved.

 

[sboegeman via AccessMonster.com]

Hi Rick -

Thanks - I was afraid of that, but it was worth a shot...

Steve

Hello -

[quoted text clipped - 4 lines]

null or unchecked checkboxes and deny the save all subforms are null
or unchecked. Can someone please let me know on how to proceed?

Can't be done. Whenever you move focus from subform to main form, subform to
subform, or main form to subform, the form losing focus is saved.