If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
executing a subform's subroutine from the main form
Hi Everyone,
Wonder if someone could help. Basically I have a main form called 'Order_header' and within it a subform called 'order_header_subform'. Attached to the subform I have a subroutine I've written called 'Totals'. What i'd like to be able to do is to call the subform's 'totals' subroutine from the main form but am unsure of the correct syntax. I have tried: [Forms]![order header]![order_header_subform].totals But without success. If anyone could point me in the right direction with this then i'd be very grateful. Many thanks David. |
#2
|
|||
|
|||
executing a subform's subroutine from the main form
Make sure the subform procedure is Public. Then in the main form, use:
Me.order_header_subform.Form.Totals David Gartrell wrote: Hi Everyone, Wonder if someone could help. Basically I have a main form called 'Order_header' and within it a subform called 'order_header_subform'. Attached to the subform I have a subroutine I've written called 'Totals'. What i'd like to be able to do is to call the subform's 'totals' subroutine from the main form but am unsure of the correct syntax. I have tried: [Forms]![order header]![order_header_subform].totals But without success. If anyone could point me in the right direction with this then i'd be very grateful. Many thanks David. -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
executing a subform's subroutine from the main form
Thanks very much for your help.
It worked perfectly! "kingston via AccessMonster.com" u27511@uwe wrote in message news:694899b6ba778@uwe... Make sure the subform procedure is Public. Then in the main form, use: Me.order_header_subform.Form.Totals David Gartrell wrote: Hi Everyone, Wonder if someone could help. Basically I have a main form called 'Order_header' and within it a subform called 'order_header_subform'. Attached to the subform I have a subroutine I've written called 'Totals'. What i'd like to be able to do is to call the subform's 'totals' subroutine from the main form but am unsure of the correct syntax. I have tried: [Forms]![order header]![order_header_subform].totals But without success. If anyone could point me in the right direction with this then i'd be very grateful. Many thanks David. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|