Re: 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@xxxxxx
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



.

Relevant Pages

  • goto next record in a datasheet
    ... I am trying to create a subroutine that will loop through a recordset of ... items and add them to a new record in a subform in datasheet mode. ...
    (microsoft.public.access.formscoding)
  • Where to start?
    ... I am unfamiliar with programming in VBA. ... However I have the need to create a subroutine that takes information from a ... subform, compares the data with data held in a table and prints ...
    (microsoft.public.access.modulesdaovba)
  • Passing fieldname to a subroutine
    ... I have a form with a subform. ... which I am assigning links to documents on the file server. ... subroutine to pass the field name parameters to. ... tried many formats and syntaxes for this with no success. ...
    (comp.databases.ms-access)
  • Re: executing a subforms subroutine from the main form
    ... Make sure the subform procedure is Public. ... David Gartrell wrote: ... 'Order_header' and within it a subform called 'order_header_subform'. ... Attached to the subform I have a subroutine I've written called 'Totals'. ...
    (microsoft.public.access.forms)
  • executing a subforms subroutine from the main form
    ... Attached to the subform I have a subroutine I've written called 'Totals'. ... But without success. ... this then i'd be very grateful. ...
    (microsoft.public.access.forms)