jwcolby
jwcolby at colbyconsulting.com
Thu May 13 22:53:53 CDT 2010
LOL, yep, .Form it is. Sorry bout that! John W. Colby www.ColbyConsulting.com Gustav Brock wrote: > Hi John > > Small correction ... > .Form it is: > > Forms!MyFrmName!MySubFormCONTROLName.Form!MyControl > > /gustav > >>>> jwcolby at colbyconsulting.com 12-05-2010 23:59 >>> > John, > > The syntax for drilling down to a subform is: > > Forms!MyFrmName!MySubFormCONTROLName.Subform!MyControl > > Forms! gets you to the forms collection > > MyFrmName gets you to a specific OPEN form (it must be open to be in the Forms collection) > > !MySubFormCONTROLName gets you to a CONTROL on the parent form which holds a subform > > .Subform gets you to the actual subform that the subform control is currently hosting / displaying > > !MyControl gets you to a specific control on that subform. > > A subform on a parent form is a CONTROL just like a text box or combo box etc. It has a PROPERTY > .Subform which returns a reference to the actual subform that the subform CONTROL is displaying. > > John W. Colby > www.ColbyConsulting.com > > > John Clark wrote: >> Thanks for this. As soon as I read it, I thought, "Doh! That is it. I can't believe I missed that." But, it actually did not fix the problem. It did change it...w/I add the parent form: >> >> "[Forms]![frmDataEntry]![frmCert_sub]![CredHours]" >> >> It give me a similar error...actually I get the same error, but then, if I try to back out of the form, I also get, "...can't find 'frmDataEntry'" >> >> In the mean time, I found an easy fix. Like I said, I inherited this program, and w/I asked where these "FTE numbers" came from, they said, "That is just what they are." OK, so they were arbitrary, I figured. I've since discovered that they are simply [CreditHrs]/30...I can't believe I went through all this work, w/it is a simple calculation. They didn't know this themselves though...w/I told them, I had to first prove it, and then they were floored..."We were always told they were [arbitrary]" >> >> I wish I had time to figure out this problem though, because I just hate leaving it, but I can repair it in 5 min., using the simple calculation. >> >> Thanks anyhow > >