MS Access, how do you allow additions in a sub form

how do you allow additions in a sub form

Author	Message
Rick Patsul #1 / 3	how do you allow additions in a sub form i have a sub form within a sub form and i have allow additions turned off on the second sub form. i want to turn it back on with a button. both sub forms are in a tab control box. here are my form names. main form frm_main sub form 1 frm_sub_education sub form 2 frm_sub_exam here is the code for the button on sub form 2 Me![frm_sub_exam].form.AllowAdditions = True the error that comes up is "can't find the field "frm_sub_exam" referred to in your expression" any suggestions thank-you rick
Mon, 10 Sep 2007 01:45:04 GMT

Steve Schape #2 / 3	how do you allow additions in a sub form Rick If the Command Button is on sub form 2, then the code would be... Me.AllowAdditions = True -- Steve Schapel, Microsoft Access MVP Quote: > i have a sub form within a sub form and i have allow additions turned off on > the second sub form. i want to turn it back on with a button. both sub forms > are in a tab control box. here are my form names. > main form frm_main > sub form 1 frm_sub_education > sub form 2 frm_sub_exam > here is the code for the button on sub form 2 > Me![frm_sub_exam].form.AllowAdditions = True > the error that comes up is "can't find the field "frm_sub_exam" referred to > in your expression" > any suggestions > thank-you > rick
Mon, 10 Sep 2007 03:01:26 GMT

Rick Patsul #3 / 3	how do you allow additions in a sub form thank-you....it works. i fought for hours trying to figure this out. Quote: > Rick > If the Command Button is on sub form 2, then the code would be... > Me.AllowAdditions = True > -- > Steve Schapel, Microsoft Access MVP > > i have a sub form within a sub form and i have allow additions turned off on > > the second sub form. i want to turn it back on with a button. both sub forms > > are in a tab control box. here are my form names. > > main form frm_main > > sub form 1 frm_sub_education > > sub form 2 frm_sub_exam > > here is the code for the button on sub form 2 > > Me![frm_sub_exam].form.AllowAdditions = True > > the error that comes up is "can't find the field "frm_sub_exam" referred to > > in your expression" > > any suggestions > > thank-you > > rick
Mon, 10 Sep 2007 03:13:06 GMT

Page 1 of 1

[ 3 post ]