Locking a form accept a subform

  • Thread starter Thread starter Stefan
  • Start date Start date
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.
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 conversion subforms don't display linked records 2
navigating controls in control tabs/subforms 3
Preventing form move 1
GoToRecord for a subform 4
Help with Child Master on Subform within Subform 4
Access Main form/Subform Navigation 0
How to always get the top level form reference, when calling from any subform/subform... 0
SUBFORM CODE 1

Back
Top