jwcolby
jwcolby at colbyconsulting.com
Wed May 12 16:59:37 CDT 2010
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