Locking a form accept a subform

S

Stefan

Hi,

I use a form with a tab-element with 4 pages.

Every page contains a subform. When a user changes data on such a subform
he/she can always click to an other page.

How can i prevent that.
 
M

Marshall Barton

Stefan said:
I use a form with a tab-element with 4 pages.

Every page contains a subform. When a user changes data on such a subform
he/she can always click to an other page.

How can i prevent that.
Click to expand...


Use each subform's BefoteUpdate event to check for whatever
conditions you're using to determine if the subform is
completed correctly. If the conditions have not been met,
then set Cancel = True to prevent the incomplete record from
being saved and keep the focus in the subform.
 
S

Stefan

Stefan said:
Use each subform's BefoteUpdate event to check for whatever
conditions you're using to determine if the subform is
completed correctly. If the conditions have not been met,
then set Cancel = True to prevent the incomplete record from
being saved and keep the focus in the subform.
Click to expand...

Thanks, i shall try it
 
Top