Trying to allow edit on a subform from a command button on the main form
I'm trying to allow edit on a sub-form from a command button on the main for with the following code. But it isn't working.
Forms!subfrmWorkOrderDetai
Can someone tell me what is wrong with the code? When I click the command button I get an error... Runtime error 2450. Can't find the referenced form.
--Steve
Forms!subfrmWorkOrderDetai
Can someone tell me what is wrong with the code? When I click the command button I get an error... Runtime error 2450. Can't find the referenced form.
--Steve
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can use:
Me.subfrmWorkOrderDetail.F
OR
Forms!yourmainformname.For
Use the "Me." syntax when referencing an object on the form where the code is running. In this case, the subform is a control on the main form where the code is running. Use the more formal reference when you are outside the scope of the object you are referencing. Just keep in mind that the object you are referencing Must be open. So, for example, if you were using a popup form instead of an embedded subform, you would need to open the popup and then use the "Forms!yourpopupformname.F
Me.subfrmWorkOrderDetail.F
OR
Forms!yourmainformname.For
Use the "Me." syntax when referencing an object on the form where the code is running. In this case, the subform is a control on the main form where the code is running. Use the more formal reference when you are outside the scope of the object you are referencing. Just keep in mind that the object you are referencing Must be open. So, for example, if you were using a popup form instead of an embedded subform, you would need to open the popup and then use the "Forms!yourpopupformname.F
Premium Content
You need an Expert Office subscription to comment.Start Free Trial