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
Post a Comment