access vba - Ensure that all pages of a tab control are clicked before closing form -



access vba - Ensure that all pages of a tab control are clicked before closing form -

i've got form 8 pages , i'd ensure pages clicked (ie. filled out) before user can close form.

and i've got subform on 1 of pages tab command 2 pages. want create sure user has filled out (clicked on) both pages before main form can close.

i don't know best way go this.

what i've got far is:

private sub tabcontrol_change() if (tabcontrol.value = 1) page2clicked = true end if end sub

and records if sec page of subform clicked or not. don't know prevent main form closing.

i utilize 8 pages on main form don't know if sufficient or not.

maybe.... hide close button?

i'm open ideas of best way go problem.

thanks!

edit: if not easy (i'm guessing not) there way create 2 tabs on subform tab command more visible user see?

hide close buton in design view.

closebutton=false

add new button in lastly page. new button should close form in click event.

access-vba ms-access-2007

Comments

Popular posts from this blog

php - Android app custom user registration and login with cookie using facebook sdk -

django - Access session in user model .save() -

php - .htaccess Multiple Rewrite Rules / Prioritizing -