[AccessD] Procedure on subform erroring out

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
> 
> 



More information about the AccessD mailing list